View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adri Adri is offline
external usenet poster
 
Posts: 4
Default Startup Template - Excel 2007/Vista

I have a template (.xltm file) containing a macro that is assigned to a
button on the QAT for that template. The macro is in ThisWorkbook.

When I just open the template, or double-click it from Windows, the button
displays and the macros runs correctly.

I want the button available all the time so I saved the template in the
Excel start folder - C:\Users\xxxx\AppData\Roaming\Microsoft\Excel\XLST ART.
When I launch Excel the button does not display, which I take it to mean the
template has not loaded. Same result if I put the template in C:\Program
Files\Microsoft Office\Office12\XLSTART. Both these startup locations are in
Trust CenterTrusted Locations.

Does anyone have any idea why the template doesn't load and display the
button?

Thanks...