With Excel 2003 worksheet "XXX" open, I wrote a macro.
I saved it the only apparent way, making it available 'to all open
worksheets"
I intended to use it on other worksheets with identical formats and similar
data.

But, to use the macro with worksheet "YYY", I must have "XXX" open.

I vaguely remember a way to save macros so they are available to
any worksheet without any other special worksheet being open.

But I can't remember how to do it and can't find how to do it.
Izzer a way?

Thanks,
Carl

Yes.

Put the common use macros in personal.xls in your XLStart folder. If you
don't have a personal.xls, make one.
--
Gary's Student


"Carl" wrote:

With Excel 2003 worksheet "XXX" open, I wrote a macro.
I saved it the only apparent way, making it available 'to all open
worksheets"
I intended to use it on other worksheets with identical formats and similar
data.

But, to use the macro with worksheet "YYY", I must have "XXX" open.

I vaguely remember a way to save macros so they are available to
any worksheet without any other special worksheet being open.

But I can't remember how to do it and can't find how to do it.
Izzer a way?

Thanks,
Carl

Carl

IMO the easiest way to have global macros available is to put them into an
add-in then checkmark that add-in in ToolsAdd-ins.

Open the workbook with the macro.

FileSave AsFile TypeExcel Add-in(*.xla).

You have to scroll to the bottom of the list to find it.

Store this add-in in your Office\Library.

You can create more macros and modules in the add-in by opening the Visual
Basic Editor and Project Explorer.

As an alternative, you can record/create macros directly into your Personal
Macro workbook(you are given that option when recording). That Personal.xls
will be stored by Excel in your XLSTART folder and open with each session of
Excel.

Save it "Hidden" so's you don't see it, but the macros will be available.

I prefer the add-in mainly because when you assign or call a macro you don't
need to preface it with the "Personal.xls"

One disadvantage of the add-in is the macros don't appear in the Macro List
under ToolsMacroMacros.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 14:49:06 -0700, "Carl" wrote:

With Excel 2003 worksheet "XXX" open, I wrote a macro.
I saved it the only apparent way, making it available 'to all open
worksheets"
I intended to use it on other worksheets with identical formats and similar
data.

But, to use the macro with worksheet "YYY", I must have "XXX" open.

I vaguely remember a way to save macros so they are available to
any worksheet without any other special worksheet being open.

But I can't remember how to do it and can't find how to do it.
Izzer a way?

Thanks,
Carl