If you will be running the macro from one machine, you might consider
putting it into your personal.xls file.

If this is not the case, you could export the module and import it into your
other files as needed.

Otherwise, you could look over this site and see if it may give you some
other ideas...

http://puremis.net/excel/code/004.shtml

Mark Ivey




wrote in message
...
Hello,

I need to copy a Macro to multiple excel file.
Is there a way to do this without the need to open every file
individually and doing the work manually?

Thanks
Ori