Automatically copy macro to multiple workbooks?

  • Thread starter Thread starter pinkfish.jm
  • Start date Start date
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!
 
One option is to export the module that the macro is stored in and then
import it back into the workbooks that need it.
 
Back
Top