LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jo Coen
 
Posts: n/a
Default open workbook automatically

I'm building a set of macro's. These macro I want to use in all different
worksheets.
So I create a PERSONAL.XLS workbook which I save in XLSTART directory.

As soon I have one file in this directory, when excel opens, the default
blank workbook does not open anymore.
What do I need to do to have the macro's available via Personal.Xls and
still have the default Book1 opened automatically.

The second problem I have is that I want to distribute these macro's to
other persons within the company. The other people probably already have
macro's in their Personal.XLS. What is the best way to distribute to multiple
people macro's?
 
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
Importing unopened worksheet into an open Workbook GrayesGhost Excel Discussion (Misc queries) 24 July 3rd 08 10:06 PM
in Excel how do you set a workbook to only open on the first work. Mark_J Excel Discussion (Misc queries) 9 February 1st 07 10:07 PM
Open Blank Workbook? rreneerob Excel Discussion (Misc queries) 0 May 25th 05 04:42 PM
Open workbook to specific worksheet Dave Excel Discussion (Misc queries) 2 May 2nd 05 08:44 PM
Excel workbook does not open in open window on desktop DeanH Excel Discussion (Misc queries) 2 March 8th 05 09:51 AM


All times are GMT +1. The time now is 03:07 PM.

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

About Us

"It's about Microsoft Excel"