View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aloha tim aloha tim is offline
external usenet poster
 
Posts: 1
Default 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?