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
|