Hey there !!
You'll be happy to know that this is really easy once you know. An "any
workbook" macro like this can be stored in your Personal Workbook - everyone
has one of these by default.
When you record a macro, you get options as to where you want to store it.
The options are in the "Store macro in:" field of the "Record Macro"
dialogue box that comes up whenever you record a macro. Just choose
"Personal Macro Workbook"
If you want to manually write a macro rather than recording one, there are
options there too :
* just record the shell of a macro to the Personal Macro Workbook and then
scribble away within the code shell, OR
* go to the VB Editor Project window and work directly in modules attached
to the Personal Workbook.
If you are running procedures that live in the Personal Workbook, you'll
need to be careful that the code is correctly referring to the workbook in
which the code should be executed (otherwise, of course, the code will try to
execute on the Personal Workbook). These references may need to be generic.
To see the actual Personal Workbook (i.e. the sheets rather than the code),
Go to the Window menu in Excel and select "Unhide". The Personal Book will
appear as an option.
