Macros available "full-time" reside in your "Personal.xls" file to be found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin