MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Macros

Posted by Dave Lane on December 20, 2001 8:18 PM

I want to copy the Macros recorded in my computer to another one but, can't figure out how to do it. I am running Microsof Office 2000.

If I could find the patch of the keyboard shortcut which activate the Macro, could I copy these to a disk and load in another computer? If so, do you know where they would be stored?

Posted by Rob on December 21, 2001 12:58 AM

When I copy macros I just go in VBA editor and copy and paste the code into a text document. Then go to the other computer and open a blank macro and go into VBA and paste it in. The other way is to use project explorer in VBA. As long as you've stored the macros in a spreadsheet and not your personal.xls you should be able to save the spreadsheet on a disk and then save it on the other comp.