On Sep 4, 6:22 am, Jay wrote:
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
--
Go Navy !!!!

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.