My current Microsoft Excel Macro that I have used for years does not work in Excel 2010. I need my macro to work in Excel 2010. My macro file is attached - hopefully the code can be used to make the new one.
I need the new Excel 2010 macro to do all of the following functions.
NUMBER FORMAT CHANGES
Hit “SHIFT + CONTROL” AND hit the following:
Hit "2" - to align within cell; should allow for 3 different alignments
Hit "3" – to change to date format (ex; 0-Jan-00)
Hit "4" – to change to % format (ex; $8.0)
Hit "5" – to change to % format (ex; 8.0%)
Hit "6" – to change to ratio format (ex; 8:1)
Hit "7" – to border the cell
Hit "8" – to change to multiple format (ex; 8X)
COLOR CHANGES
Hit “CONTROL” AND
Hit "Semicolon" (changes color from black to blue to black to blue, etc)
Hit "Apostrophe" (changes color to black, blue, red, purple, green, white)
DECIMAL CHANGES
Hit “CONTROL” AND
Hit "J" to increase the number of decimal places
Hit "K" to decrease the increase the number of decimal places
Hello,
My bid is for Creation of Macro.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
Kind regards.
I'm experienced in both Excel versions, I'll complete the project in some hours provided you send me an unprotected version of the present XLA (the attached one is unviewable). Regards
It is not a problem with the version of MS Office, but with the fact that the programming of the old macro was implemented as an external component which was lost when you switched to Office 2010. Our offering is to re-implement the functionality according to the requirements you mention in the project description.
This Project should be really simple and easy. If you have an unprotected version (without password or the password if you remember), i assure you that I can do it quickly. Even without the unprotected workbook it would be easily doable with a little more effort and time.
I have been a go to person for Excel - VBA related queries in my organization and have done lot of models in excels with VBA. Please mail me the details if I can start working on it right away.