Excellent, it worked!

Thanks so much.

Cheers,
Colin


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Colin

Select Personal.xls from Window and "Hide".

Close Excel and when asked click "yes" to "do you wnat to save changes
etc."

Peronal.xls will now open "hidden" when you start Excel.

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 19:23:36 -0500, "Colin Higbie"
wrote:

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