How to AutoLoad Macro
 

I have a VBA macro which in previous versions of Excel worked great. I made a
button on the menu line and it was always there when I open excel. I now have
Excel 2007 and th only way I can this this macro to load each time I open
Excel is to place it in the XTStart folder. This forces me to close 2 files
each time I exit excel. Is there another way to have a macro (which is on the
quick access toolbar) accesible without loading 2 seperate files?

How to AutoLoad Macro
 

You have to read down the page quite a way, but I think it will give you what
you are looking for.

http://office.microsoft.com/en-us/ex...141111033.aspx

"aloha tim" wrote:

I have a VBA macro which in previous versions of Excel worked great. I made a
button on the menu line and it was always there when I open excel. I now have
Excel 2007 and th only way I can this this macro to load each time I open
Excel is to place it in the XTStart folder. This forces me to close 2 files
each time I exit excel. Is there another way to have a macro (which is on the
quick access toolbar) accesible without loading 2 seperate files?