Startup Template - Excel 2007/Vista


A

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...
 
Ad

Advertisements

G

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
 
A

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?
 
G

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
 
A

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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top