2003: template shortcut
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. |
2003: template shortcut
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. |
2003: template shortcut
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. |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com