MrExcel Publishing
Your One Stop for Excel Tips & Solutions

automatically starting a dialog


Posted by Luc Neville on February 02, 2000 6:25 AM

I'd like to know if it's possible in excel to let a dialog for opening files automatically appear at the start-up of excell. and if so how


Posted by Celia on February 02, 2000 11:03 AM


The built-in Excel dialog box for opening files can be automatically displayed when Excel is opened as follows :-

Put one of the following macros in an Excel file and put the file in the XLstart folder.

Either in a normal module :-

Sub Auto_Open()
Application.Dialogs(xlDialogOpen).Show
End Sub

Or preferably, in the workbookÂ’s event handler code sheet:-

Private Sub Workbook_Open()
Application.Dialogs(xlDialogOpen).Show
End Sub