I want to move a macro from one spreadsheet to another.
What is the way to either move or copy a macro?

Thanks.
Alex

Alex,

Open both the source and destination workbooks. Then open the
VBA Editor. In the Project Explorer window (typically on the
left side of the screen), drag the module containing the code
from the source project to the destination project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Alex" wrote in message
...
I want to move a macro from one spreadsheet to another.
What is the way to either move or copy a macro?

Thanks.
Alex

If you export the module from the VBA editor you can reimport into another
sheet or you can copy and paste it.
But if you have a common macro, why not put it in the personal workbook or
create a template with the macros in it that can be used for new workbooks.

Lots of options, so it does depend on how and to what extent you need to do
this?

Cheers
Nigel

"Alex" wrote in message
...
I want to move a macro from one spreadsheet to another.
What is the way to either move or copy a macro?

Thanks.
Alex




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---