Want NO new workbook at startup

[Robert Wagner]

I'm using Excel 2004 under OS X (10.2.8) . By default, starting the app
always opens a new window into a new workbook. I don't want that. Is
there a way to defeat it?

TIA, Robert R. Wagner
ExpanTest

 

[CyberTaz]

You might want to take a look at

"About customizing Excel startup defaults"

In Excel Help.

Hope this is useful |:>)

I'm using Excel 2004 under OS X (10.2.8) . By default, starting the app
always opens a new window into a new workbook. I don't want that. Is
there a way to defeat it?

TIA, Robert R. Wagner
ExpanTest

-- (e-mail address removed)

 

[Robert Wagner]

Actually, I'd already looked at "About customizing Excel startup
defaults". There doesn't seem to BE any way of preventing a new workbook
appearing at startup. Of course, in the Windows version there is: You
simply add "/e" after the Target path in a shortcup (oops--alias!)
linking to the application.

Have I missed something about the Mac version here?

TIA >>> Robert

 

[JE McGimpsey]

Actually, I'd already looked at "About customizing Excel startup
defaults". There doesn't seem to BE any way of preventing a new workbook
appearing at startup. Of course, in the Windows version there is: You
simply add "/e" after the Target path in a shortcup (oops--alias!)
linking to the application.

Have I missed something about the Mac version here?

No, you haven't missed anything.

However, if you put this in the ThisWorkbook code module of an add-in
that you store in the

Microsoft Office 2004:Office:Startup:Excel:

folder, the Workbook1 workbook will be closed when you start XL:

Private Sub Workbook_Open()
Dim wb As Workbook
For Each wb In Workbooks
If wb.Name = "Workbook1" Then
wb.Close SaveChanges:=False
Exit For
End If
Next wb
ThisWorkbook.Close SaveChanges:=False
End Sub

you could do something similar with an alias - just have the workbook
close itself in the Workbook_Open() event macro.

I've posted the add-in at

ftp://ftp.mcgimpsey.com/excel/noworkbook.xla

 

[Robert Wagner]

I tried the add-in, but it caused an error: "Microsoft Excel is being
opened by another user. Open as read-only?" Clicking "OK" just brings it
up again. Clicking "Cancel" brings up the Excel "needs to close"
message.

I tried to create the add-in myself, but I can't even figure out how to
create a project. (I've had a lot of experience in programming Access 97
on the PC, but none in any version of Excel.)

What next?

TIA >>> Robert