moving macros between spreadsheets

A

Alex

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

Thanks.
Alex
 
C

Chip Pearson

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
 
Top