File - New, bypassing task pane
 

Hi,

Excel 2003. I want to change the behavior of the File - New menu item
to act like it did in Office 2K.

Specifically, When I click File - New I dont want the Task Pane to open, I
would like the templates dialog to open. I have been able to do this in
Word by choosing Tools - Customize - ALL COMMANDS category;
its name is FileNewDialog.

It appears that Excel doesn't have the "All Commands" option. Is it possible
to
change this behavior in Excel.

Thanks

File - New, bypassing task pane
 

I believe the Excel VBA equivalent for the dialog box is
Application.Dialogs(xlDialogNew).Show

However, in my XP xl2003 when I use FileNew I get a display in a panel to
the right of the worksheet that shows Online Templates as an option, in
addition to new workbook. Don't know exactly what you are after but
sometimes the different version looks different but does the same thing, or
better.


"Jack B. Pollack" wrote:

Hi,

Excel 2003. I want to change the behavior of the File - New menu item
to act like it did in Office 2K.

Specifically, When I click File - New I dont want the Task Pane to open, I
would like the templates dialog to open. I have been able to do this in
Word by choosing Tools - Customize - ALL COMMANDS category;
its name is FileNewDialog.

It appears that Excel doesn't have the "All Commands" option. Is it possible
to
change this behavior in Excel.

Thanks

File - New, bypassing task pane
 

You can right-click a sheet tab and choose "Insert..." to display a Templates list.
'--
Jim Cone
Portland, Oregon USA



"Jack B. Pollack"

wrote in message
Hi,
Excel 2003. I want to change the behavior of the File - New menu item
to act like it did in Office 2K.

Specifically, When I click File - New I dont want the Task Pane to open, I
would like the templates dialog to open. I have been able to do this in
Word by choosing Tools - Customize - ALL COMMANDS category;
its name is FileNewDialog.

It appears that Excel doesn't have the "All Commands" option.
Is it possible to change this behavior in Excel.
Thanks

File - New, bypassing task pane
 

Thanks. That will work.


"JLGWhiz" wrote in message
...
I believe the Excel VBA equivalent for the dialog box is
Application.Dialogs(xlDialogNew).Show

However, in my XP xl2003 when I use FileNew I get a display in a panel to
the right of the worksheet that shows Online Templates as an option, in
addition to new workbook. Don't know exactly what you are after but
sometimes the different version looks different but does the same thing,
or
better.


"Jack B. Pollack" wrote:

Hi,

Excel 2003. I want to change the behavior of the File - New menu item
to act like it did in Office 2K.

Specifically, When I click File - New I dont want the Task Pane to open,
I
would like the templates dialog to open. I have been able to do this in
Word by choosing Tools - Customize - ALL COMMANDS category;
its name is FileNewDialog.

It appears that Excel doesn't have the "All Commands" option. Is it
possible
to
change this behavior in Excel.

Thanks