Accessing FILE > NEW > ON MY COMPUTER ... [XL2003]

[ngmail]

In XL2K, the button that we could put on our toolbar always accessed
the templates on the computer, i.e., as in the subject line, FILE >
NEW > ON MY COMPUTER. As of 2003, we get an intermediary step where
we have to choose from online, on computer, etc. I'll keep that new
button but I'd like to have the old style one that directly pulls up
the dialogue box that lets me access my saved templates.

I can't find this option anywhere in the Commands tab when I go to
customize the toolbar so I'm guessing that maybe the only way may be
to access the same via a VB command. Does anyone know what would open
the old XL2K Templates dialogue box directly, pls?

Thanks! I can then attach that to a button on my toolbar so that I
have both the "old" way and the "new" way of getting to templates.

Thanks! D

 

[ngmail]

VB code for FILE > NEW > ON MY COMPUTER, is there such a thing? I've
tried recording a macro but since it deals with a dialog box, doesn't
work. Thx.

 

[Dave Peterson]

Application.Dialogs(xlDialogNew).Show

VB code for FILE > NEW > ON MY COMPUTER, is there such a thing? I've
tried recording a macro but since it deals with a dialog box, doesn't
work. Thx.

 

[ngmail]

Application.Dialogs(xlDialogNew).Show

Awesome, thanks. That did the trick. <g>