Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Automatically copy macro to multiple workbooks?

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!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Automatically copy macro to multiple workbooks?

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I copy multiple formulas between workbooks at once? Hank Excel Worksheet Functions 1 September 23rd 09 12:06 AM
macro: copy multiple workbooks to multiple tabs in single book Michael Excel Programming 0 July 14th 06 04:53 PM
How to consolidate workbooks automatically from multiple emails? CCSMCA Excel Programming 4 February 9th 06 10:31 PM
Update multiple workbooks automatically golfer Excel Worksheet Functions 1 December 23rd 04 08:39 PM
Automatically applying a macro to many workbooks Chip Pearson Excel Programming 2 July 20th 04 01:16 AM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"