How do I move a Macro from Personal.xls to another workbook?

[sunday_storyteller]

I have several Maros in Personal.xls. I would like those Macros to be available to other people. The Macros act entirely on a workbook called Template.xls. I would like, therefore to move the Macros to reside in Template.xls instead of Personal.xls.

How can I do this without re-writing/re-recording them?

Thanks!

Calinda

 

[Datsmart]

Open VBE (Alt-F11)
Find the code in your Personal.xls project.
Copy and paste to the module in your other workbook.

 

[sunday_storyteller]

Thank you so much! You are so helpful.

That saved me hours of work...probably a full day's worth. Because there were alot of macros.