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

Startup Template - Excel 2007/Vista
 

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

Startup Template - Excel 2007/Vista
 

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


.

Startup Template - Excel 2007/Vista
 

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


.

Startup Template - Excel 2007/Vista
 

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


.


.

Startup Template - Excel 2007/Vista
 

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


.


.

Startup Template - Excel 2007/Vista
 

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


.


.


.

Startup Template - Excel 2007/Vista
 

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


.


.


.