Bypass New Workbook pane

[Samuel C]

Excel 2003. Is there a way to bypass the New Workbook pane when
opening templates on this computer. So you would just click File, New
and it would open the Templates window at once.

If not, is there a way to have more "recent" templates in the New
Workbook pane than the actual 4?

 

[Dave Peterson]

Maybe you can use a macro?

Option Explicit
Sub testme()
Application.Dialogs(xlDialogWorkbookNew).Show
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to test it to see if it's sufficient, you can:
Hit alt-f11 (to open the VBE)
hit ctrl-g (to get to the immediate window)
type this and hit enter:
Application.Dialogs(xlDialogWorkbookNew).Show

If you like it, then you can implement it as a macro (in your personal.xls
workbook??)

 

[Jim Cone]

Also try right-clicking the sheet tab and selecting insert.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Samuel C" <[email protected]>
wrote in message
Excel 2003. Is there a way to bypass the New Workbook pane when
opening templates on this computer. So you would just click File, New
and it would open the Templates window at once.

If not, is there a way to have more "recent" templates in the New
Workbook pane than the actual 4?