Automatically copy macro to multiple workbooks?

P

pinkfish.jm

Is there a way to create one macro and automatically copy this macro to
other workbooks? I can't use the personal.xls file, because the
workbooks will be used by multiple users. I'm also using a mac.

Thanks!
 
G

Guest

One option is to export the module that the macro is stored in and then
import it back into the workbooks that need it.
 

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

Unwanted workbooks on startup 2
Sharing and Changing a Macro in Multiple Workbooks 11
Switching workbooks with Personal.xls 3
COPY MODULE MACRO WITH WORKSHEET TO OTHER WORKBOOKS 2
MACRO TO COUNT ALL OPEN WORKBOOKS and print 1
Split Workbook into Multiple Workbooks 5
Macro to copy sheets to another workbook fails after about 45 copi 3
Copy user selected range from all open workbooks 2

Top