Opening excel

[mickocollin]

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When excel starts up/opens it always gives me a blank new workbook. How do I stop that from happening?

mick

 

[JE McGimpsey]

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When excel starts up/opens it always gives me a blank new workbook. How do I
stop that from happening?

You can't do that in the interface (BTW: the behavior is in accordance
with MacOS X guidelines). However, you can do it with an event macro.
Put this in the ThisWorkbook module of your Personal Macro Workbook:

Private Sub Workbook_Open()
Dim wbFirst
Set wbFirst = Workbooks("Workbook1")
If Not wbFirst Is Nothing Then wbFirst.Close
Debug.Print "Ran"
End Sub