Bypass Workbook_Open when opening a workbook with VBA

[Paul]

Hi there,

How can I bypass the Workbook_Open event when opening a workbook with
VBA.

Holding down the shift key does this when opening it manually. The
open event simply brings up a message box which normally a user would
just click OK.

I have tried Sendkeys, but this does not work. Can't find anything in
the help files.

Any suggestions welcome.

Cheers

Paul

 

[Tom Ogilvy]

Application.EnableEvents = False
workbooks.Open "C:\Myforlder\MYfile.xls"
Application.EnableEvents = True

 

[Paul]

Thanks Tom,

Obvious when you see it.

Have a great day. Cheers. Paul