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