open dialog box

[Guest]

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]

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.