LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 137
Default Excel Macro Advise.....To Open The Template Dialog.....

I am using Excel 2002 and 2003 and get diferent results from this macro.
Using a macro to open the Templates Dialog.....Advise Please.

Sub AutoExec( )

Application.Dialogs(xlDialogNew).Show

End Sub

When Running from within the VBE of Excel 2003 it will work ...Open the
Dialog Box.
but it will not run on startup as expected of an AutoExec.

When Running on Excel 2002, it doesn't appear to run al all fron within the
VBE to test it or on Startup.
If I step through it in the VBE, nothing happens.

All suggestions would be appreciated. Thanks



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Macro Dialog Box Steven Excel Programming 1 July 26th 04 10:34 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
end Macro after cancelling open dialog No Name Excel Programming 1 June 29th 04 08:58 AM
Open file Dialog box in Macro Joshua Excel Programming 6 April 4th 04 01:44 AM
Open dialog in macro Matt Excel Programming 1 February 21st 04 06:34 PM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"