LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default Separate Macro from Workbook

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh
 
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
Run code from separate workbook Mike Excel Programming 3 July 31st 07 07:02 PM
Range name in separate workbook Arun Excel Discussion (Misc queries) 0 November 30th 06 08:42 PM
Select sheet tabs in workbook & save to separate workbook files stratocaster Excel Worksheet Functions 2 March 1st 06 03:35 PM
userform in a separate workbook? Gary Keramidas Excel Programming 2 November 2nd 05 06:18 PM
Issuing macro in workbook from separate workbook Nigel Excel Discussion (Misc queries) 1 May 16th 05 05:46 PM


All times are GMT +1. The time now is 10:39 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"