Open Event

[Guest]

Anyone know how to open a work book through code and suppress the any code
that is in the open event of the book being opened?

I know you can do it manually by holding the shift key to go into design
mode so there must be a VBA equivalent mustn't there?

 

[Ron de Bruin]

Hi Andy

Use EnableEvents

Sub test()
Application.EnableEvents = False
Workbooks.Open "C:\Data\test1.xls"
Application.EnableEvents = True
End Sub


Or put your code in this sub

Sub Auto_open()

End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro

 

[Guest]

Thanks Ron

Andy

Hi Andy

Use EnableEvents

Sub test()
Application.EnableEvents = False
Workbooks.Open "C:\Data\test1.xls"
Application.EnableEvents = True
End Sub


Or put your code in this sub

Sub Auto_open()

End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro