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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
auto copy total from one workbook to another workbook 1
copy data from one excel workbook to another workbook using macro 4
move worksheet to end of another workbook 3
Copy formulas from one workbook to another 1
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook 1
sum of mutiple entries on another workbook 6
macro to call other macros 1

Top