A good way to have all your macros accessible each time
you open excel is to save all your macros to a file called
personal.xls and put this in the following directory:
\Program Files\Microsoft Office\Office10\XLStart (I'm
running XP, so it might be slightly different in 2000.
Also, you might have to change the folder options to view
hidden folders and files to see this directory.)

When you open up excel, this file will open
automatically. Then, under the window menu, click hide.
This way, excel will open up a file each time with your
macros, but the fact that an additional file is open will
be transparent to you.

Hope this helps. I found this solution after trolling
around the microsoft website for a while.


-----Original Message-----
I'm trying to save a macro in a template (.XLT) but when
I
reopen the template its gone. I mean when I go into Tools-
-
Macro--Macros, I dont see it?

Can I do this? Sorry, I'm new to Excel.
I'm using Windows 2000 and Excel 2000

Can I run a macro in a template to test it, or do I have
to save to an XLS before running it. I'm confused.
.