New Command Excel 2002

  • Thread starter Thread starter MarkC
  • Start date Start date
M

MarkC

I like to be able to click on "New" and have the General Template Window
come up. Presently Workbook pane comes up and I have to click on the
General Template link to get to that screen. I like to be able to do that
in one click and not two.

In Word, I found a command "New Other". Clicking on "New Other" brought up
the Template screen. Does Excel 2002 have that too? I tried to find it,
but could not...

thanx.
M
 
One Solution via macro:

Sub NewBook()

Application.Dialogs(xlDialogNew).Show

End Sub

You'll have to save this in a File that will be open whenever you bring up
Excel. If you have a Personal Macro Workbook, put it in there. If not, you'll
need to create it.
If you're aren't sure how, check out this website:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

tj
 
um, forgot to add, that you'll need to create a Toolbar Button for it.
Go to Tools | Customize | Commands
find the Macro Category
Drag the Smiley to a Toolbar
Modify the Pic as desired by clicking Modify on the Dialog Box
You can even Copy and Paste the Image from the Standard New Button, and then
remove the Standard New Button from the Toolbar.

tj
 
Back
Top