is it possible to have a shortcut to a template?

dragon007

New Member
Joined
Aug 6, 2002
Messages
43
hi everybody,

is it possible to have a shortcut to a template? i mean instead of going everytime to FILE>NEW and choose a template, you just have it somewhere on the toolbar as a button for example.
thanks.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Phil Squod

New Member
Joined
Sep 7, 2002
Messages
8
You could either add a button to the MS Office ShortCut Bar, or in Excel you could record a macro to open your template and assign the macro to a toolbar button.
 

dragon007

New Member
Joined
Aug 6, 2002
Messages
43
thanks Phil,
actually i would go with your first suggestion. can you please let me know how to do that.
thanks
 

Phil Squod

New Member
Joined
Sep 7, 2002
Messages
8
This must be easy to find in the Windows help file, but anyway :-

Right-click on the ShortCut bar
Select Customize>Buttons>AddFile and select the file you want to add.
 

Forum statistics

Threads
1,144,291
Messages
5,723,532
Members
422,502
Latest member
barakgahtan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top