Automatically copy macro to multiple workbooks?

's Computer Specifications

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!

's Computer Specifications

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

"pinkfish.jm" wrote:

> 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!
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Copy Mulitple Worksheets to New Multiple Workbooks	=?Utf-8?B?SWFu?=	Microsoft Excel Programming	8	13th Mar 2007 05:16 PM
macro: copy multiple workbooks to multiple tabs in single book	=?Utf-8?B?TWljaGFlbA==?=	Microsoft Excel Programming	0	14th Jul 2006 04:53 PM
Update multiple workbooks automatically	=?Utf-8?B?Z29sZmVy?=	Microsoft Excel Worksheet Functions	1	23rd Dec 2004 08:39 PM
Re: Automatically applying a macro to many workbooks	Chip Pearson	Microsoft Excel Programming	2	20th Jul 2004 01:16 AM
Copy a macro between workbooks	Tio	Microsoft Excel Worksheet Functions	1	23rd Feb 2004 08:52 PM