Excel start up without workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As a default, Excel starts with an empty workbook (Book1).
I want Excel to start up empty, with no workbooks at all. How can I do this?
 
AFAIK there is no UI setting for this. You could set a Workbook_Open event
in your personal.xls to close the activeworkbook. Just tested it and it
seems to work

Private Sub Workbook_Open()
ActiveWorkbook.Close SaveChanges:=False
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Append a /e to the end of your shortcut to open Excel with no splash or Book1.

OR better yet.......

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp>/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP
 
Back
Top