copy one macro to another workbook

J

Jay

hello all, I am looking to copy a macro from one workbook on my hard drive
to another workbook that is located on a server. is there an easy way to
accomplish this as I have a number of workbooks that need the same treatment.
Thanks again, everyone for the great questions and the superb answers!! J
 
S

Spiky

hello all, I am looking to copy a macro from one workbook on my hard drive
to another workbook that is located on a server. is there an easy way to
accomplish this as I have a number of workbooks that need the same treatment.
Thanks again, everyone for the great questions and the superb answers!! J
Click to expand...

Open both workbooks. Go into VBA (ALT-F11) and open the Project
Explorer (CTRL-R). You can either open a module and copy the text of
the macro to a new Module in the 2nd workbook or just drag an entire
module to the other workbook in the Explorer and it will copy.

Don't forget to save.
 
J

Jay

Roger that, I was hoping it was an easy fix. I really enjoy coming on
this web page and learning more and more excel everyday. HooRah Go Navy!
 
Top