I use a specific template 4 or 5 times a day but it is not my usual Excel
screen. Is it possible to put a button on the toolbar or have some other
shortcut that will allow me to open the template without going to File, New,
Template, blah, blah, blah?

I tend to just go to the Open icon; then I have to close that new blank
workbook and go to New and on and on... I would like to compensate for my own
memory with an easy little button.

Thank you in advance.

You could record a macro whilst opening the Template. Assign that macro to
a button on a Toolbar

This is what I got through recorder............altered to prevent line-wrap

Sub Macro1()
Workbooks.Add Template:= _
"C:\Documents and Settings\Gord\Application Data\Microsoft" & _
"\Templates\Family monthly budget.xlt"
End Sub

Try it yourself and see what you come up with.


Gord Dibben MS Excel MVP

On Wed, 5 Nov 2008 15:18:11 -0800, cleo_cat
wrote:

I use a specific template 4 or 5 times a day but it is not my usual Excel
screen. Is it possible to put a button on the toolbar or have some other
shortcut that will allow me to open the template without going to File, New,
Template, blah, blah, blah?

I tend to just go to the Open icon; then I have to close that new blank
workbook and go to New and on and on... I would like to compensate for my own
memory with an easy little button.

Thank you in advance.

Thank you. I'll try it. I haven't done macros before.

"Gord Dibben" wrote:

You could record a macro whilst opening the Template. Assign that macro to
a button on a Toolbar

This is what I got through recorder............altered to prevent line-wrap

Sub Macro1()
Workbooks.Add Template:= _
"C:\Documents and Settings\Gord\Application Data\Microsoft" & _
"\Templates\Family monthly budget.xlt"
End Sub

Try it yourself and see what you come up with.


Gord Dibben MS Excel MVP

On Wed, 5 Nov 2008 15:18:11 -0800, cleo_cat
wrote:

I use a specific template 4 or 5 times a day but it is not my usual Excel
screen. Is it possible to put a button on the toolbar or have some other
shortcut that will allow me to open the template without going to File, New,
Template, blah, blah, blah?

I tend to just go to the Open icon; then I have to close that new blank
workbook and go to New and on and on... I would like to compensate for my own
memory with an easy little button.

Thank you in advance.