2003: template shortcut

[cleo_cat]

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.

 

[Gord Dibben]

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

 

[cleo_cat]

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