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

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.

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


On Tue, 22 Dec 2009 08:27:01 -0800, Adri
wrote:

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.

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" wrote:

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


On Tue, 22 Dec 2009 08:27:01 -0800, Adri
wrote:

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.


.

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

On Tue, 22 Dec 2009 13:12:01 -0800, Adri
wrote:

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" wrote:

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


On Tue, 22 Dec 2009 08:27:01 -0800, Adri
wrote:

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.


.

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

"Gord Dibben" wrote:

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

On Tue, 22 Dec 2009 13:12:01 -0800, Adri
wrote:

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" wrote:

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


On Tue, 22 Dec 2009 08:27:01 -0800, Adri
wrote:

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.


.


.

Good to hear.


Gord

On Wed, 23 Dec 2009 10:06:02 -0800, Adri
wrote:

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

"Gord Dibben" wrote:

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

On Tue, 22 Dec 2009 13:12:01 -0800, Adri
wrote:

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" wrote:

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


On Tue, 22 Dec 2009 08:27:01 -0800, Adri
wrote:

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" wrote:

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

On Mon, 21 Dec 2009 14:47:01 -0800, Adri
wrote:

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


.


.


.