MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying a macro


Posted by Dee on November 14, 2001 12:07 PM

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


Posted by Juan Pablo on November 14, 2001 12:10 PM

One way is export it from the first Wbook, (In VB Editor, right click in the module, Export...), then in the second one, right click in one of the sheets module (Or in any module), click Import, and select file.

Other, somewhat obvious, Copy - Paste. To do this while running a macro, check out Chip Pearson's page. http://www.cpearson.com

Juan Pablo

Posted by Dee on November 14, 2001 12:21 PM

Thank you. You answered a question about the Paste Value icon & I found it & added it to my toolbar but it's dimmed out & therefore unusable. Ehat do I do now?

Posted by Juan Pablo on November 14, 2001 12:26 PM

Just select a range, copy it (Either by clicking the copy button or Ctrl + C), and then it should be "available".

Juan Pablo

Posted by Dee on November 14, 2001 12:36 PM

You're fantastic! Thank you again!