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?

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andy" wrote in message ...
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?

Thanks Ron

Andy



"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andy" wrote in message ...
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?