Copying A Macro to Additional Excel Files

[lkmw]

Hello -- I'm new to macros and need some help...seems like this should be easy but I'm having trouble. The answer I found in Excel's HELP is not working for me.

I wrote a very simple macro in one excel file that prints several worksheets in the file. I want this same macro in additional Excel files. How do I copy it to the additional files?

Thanks

 

[Crow_23]

You don't need to copy macros to other workbooks. Simply have the workbook open or hidden so that the macro will always be there. I usually designate one workbook for all macros to keep things central. To hide the workbook simply do a Window-->Hide

 

[KenCriss]

You can also export it in the VBE and then import it into whatever workbook you want it in.

 

[lkmw]

Thanks...both of these worked. Much appreciated.