The "other option" is not difficult.
Anything you save in the "Personal.XLS" will always be available when you open Xl.
Personal.xls is "open" but hidden.
FWIW, my method for storing macro's is to set them in another workbook which is also
hidden and placed in an alternate Startup folder. I tell XL where this folder is located
("Tools-Options-General" - "Alternate startup file location"). Anything placed here will
automatically be available when Excel is started (as will the Personal.xls which resides
in the default startup directory).
Either way, the macro(s) will be available. In my case, I have several utility type
macro's which I create buttons for and put them on a toolbar which is part of my default
workbook. This allows me to execute them on any open workbook.

--
Regards;
Rob
------------------------------------------------------------------------
"Anonymous" wrote in message
...
<snip

the other option is to create a macro, but this is more difficult because
you need to save it in a workbook under personal macro. It gives you this
option when you create the macro. btu then this workbook needs to be open
any time you want to use the macro. so you will have to open both the
document you want to use the macro in and the document personal where you
saved the macro.

<snip