MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy a macro

Posted by Erin on December 21, 2001 7:14 AM

Is there a way to copy a macro from one computer to another?

Posted by Mark O'Brien on December 21, 2001 7:32 AM


The simple answer is just to copy the workbook with the macros onto the other computer.

If this doesn't work then the macro is probably in their personal.xls. For an reasonably detailed explanation of this, then goto this link and start at Step 4. :

Any problems, just repost.

Posted by Jack in UK on December 21, 2001 11:31 AM

Export the macro default is *.bas and email, floppy and then inport it, so copy no as you cant paste it but load in you can.