How to save a macro, such that it is available for all excel files.
I tried to save, but it always saves in a particular file. How it can be made
available to all excel files?

Please help

hsg

Hi
save your macro in the personal.xls file

--
Regards
Frank Kabel
Frankfurt, Germany

hsg wrote:
How to save a macro, such that it is available for all excel files.
I tried to save, but it always saves in a particular file. How it can
be made available to all excel files?

Please help

hsg

I did not find any file named "personal.xls" on searching computer. If that
is to be created, where should it be placed? I am using Excel 2003.

"Frank Kabel" wrote:

Hi
save your macro in the personal.xls file

--
Regards
Frank Kabel
Frankfurt, Germany

hsg wrote:
How to save a macro, such that it is available for all excel files.
I tried to save, but it always saves in a particular file. How it can
be made available to all excel files?

Please help

hsg

Hi,

Frank's reply was correct, but didn't consider language defaults.
The name of the personal macro workbook depends on the language version of
Excel you're using.

For instance in a Dutch version the workbook is called: "persnlk.xls".

However there are ways of detecting the name and location of your perssnal
macro workbook.

First:
try finding folder "xlstart" this is the location where Excel normally
stores the personal macro workbook.
Then lok for the files (any file) stored.

Second:
Go to menu Window. Give command Unhide.
The personal macro workbook should be hidden.
If you unhide the workbook and then try to save as... the browser should
detect the path where the file is stored at the moment.
Just write down the path and you know where to find the personal macro
workbook.

HTH

regards,

Sybolt