copy one macro to another workbook

  • Thread starter Thread starter Jay
  • Start date Start date
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
 
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.
 
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!
 
Back
Top