open workbook automatically

[Guest]

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?

 

[Norman Jones]

Hi Jo,

Hide your Personal.xls and close Excel, accepting the save prompt.

When you re-open Excel, Personal.xls will open hidden and a blank workbook
will be opened.


Save the macros that you want to distribute in a new workbook. Open the VBE
(Alt-F11), in the explorer window (Ctrl-R) select the workbook's
ThisWorkbook module, open the properties window (F4) and change the value of
the IsAddin property to True. Save the workbook (as 'Jo Coen Macros', say) ,
selecting the Microsoft Excel addin (*.xla) option in the file type option
list.

If your co-workers load the addin, your macros will be available to any
workbook that they open.

 

[moi]

Maybe not according to all conventions, but if I have a bunch of macro's
that I want to use in all my workbooks, I save my file as .XLA and use it as
an add-in, which still works quite well.