Open workbook without running Workbook_Open Event

[Domenick]

I'm using Excel 2007. How do I open a workbook (the workbook is a .xls
97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down
the SHIFT key while opening as this worked in previous versions of Excel, but
the event still runs (unfortunately, there is an ActiveWorkbook.Close at the
end of my code so I can't get in to modify it

I'm sure there is a simple way to do this in 2007 but I do not know it.
Thanks for the help.

 

[Ron de Bruin]

Hi Domenick

I read more about this problem
Works OK for me when I use Office Button>Open and hold the Shift key

Change your security so you have the option to disable Macro's

 

[B Lynn B]

There are lots of times when I don't want events to "fire" besides just
workbook open, so I've put a little sub in my personal.xlsb to toggle
Application.EnableEvents between True and False, and assigned it to a custom
button on my quick launch toolbar. Then I just open Excel and click the
custom button to disable events before opening a file where I don't want the
Open event code to run.

 

[Domenick]

That's a good suggestion. Just curious: Does your custom button indicate
whether the EnableEvents is ON or OFF (perhaps "pushed in" for ON)? If so,
how did you do this? Thanks.

 

[Gord Dibben]

Private Sub CommandButton1_Click()
With Application
If .EnableEvents = True Then
.EnableEvents = False
CommandButton1.Caption = "Disabled"
Else
.EnableEvents = True
CommandButton1.Caption = "Enabled"
End If
End With
End Sub


Gord Dibben MS Excel MVP