Startup Template - Excel 2007/Vista

[Adri]

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\XLSTART.
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 Center>Trusted Locations.

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

Thanks...

 

[Gord Dibben]

Template files *.xltx and *.xltm in XLSTART do not automatically load
when Excel starts.

*.xlsx and *.xlsm will start automatically.

Templates have to be manually loaded or loaded from a shortcut when opening
Excel.


Gord Dibben MS Excel MVP

 

[Adri]

Thanks for the info Gord...

If I make it an .xlsm, it opens the file when Excel starts, whereas I just
want the macro to be available - i.e. to display the customized QAT.

I'm going to want to deploy this to everyone on our network, that's why I
thought of copying a template to their startup folder at login...I thought an
Excel startup template would work like a Word startup template, but
apparently not.

How would I make the macro always available every time Excel is launched?

 

[Gord Dibben]

I would create an add-in and store the add-in in a folder that is accessible
to all users.

Instruct them to load the add-in and keep it loaded.

You can code in the add-in to create the button then delete when Excel or
add-in is closed.


Gord

 

[Adri]

Thanks for your advice..I found a very good article on creating add-ins, so
I'm sure I'll be able to get what I need.

Adri

 

[Gord Dibben]

Good luck with the project.

If you want help creating and deleting a button or toolbar or menuitem see
Debra Dalgleish's site for some Dave Peterson coding.

http://www.contextures.on.ca/xlToolbar02.html


Gord

 

[Adri]

I created my add-in and it works exactly as needed...thanks.

 

[Gord Dibben]

Good to hear.


Gord

I created my add-in and it works exactly as needed...thanks.