Bypass New Workbook pane

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Samuel C - 06 Sep 2006 10:38 GMT

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?

Reply to this Message

Dave Peterson - 06 Sep 2006 13:40 GMT

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??)

> 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?

Signature

Dave Peterson

Reply to this Message

Jim Cone - 06 Sep 2006 17:51 GMT

Also try right-clicking the sheet tab and selecting insert.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Samuel C" <scaleolu.nospam@gmail.com>
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?

Reply to this Message

Rate this thread: