There was no Personal.xls file in the XLStart folder. I created it, now it
opens as a workbook every time I start Excel. It did successfully globally
enable the macro, as you said.

How do I get the macro without the rest of the workbook?

Thanks,
Colin


"Jim May" wrote in message news:wPzid.4$C%4.1@lakeread04...
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