open dialog box
 

hi,

how do i get the open dialog box to come up automatically
when i open excel??

I have a boss that wants that....and I aim to please.

Also, how can i make the columns in the open dialog box in the view
come closer together so there are more spreadsheets in the open dialog box?

thanks

open dialog box
 

You'll have to create a new workbook and store it in his XLStart folder:

Option Explicit
Sub Auto_Open()
Application.Dialogs(xlDialogOpen).Show
ThisWorkbook.Close savechanges:=False
End Sub

Or you could tell him to use ctrl-o.


carrie wrote:

hi,

how do i get the open dialog box to come up automatically
when i open excel??

I have a boss that wants that....and I aim to please.

Also, how can i make the columns in the open dialog box in the view
come closer together so there are more spreadsheets in the open dialog box?

thanks

--

Dave Peterson