Bypass Workbook_Open when opening a workbook with VBA
 

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

Bypass Workbook_Open when opening a workbook with VBA
 

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

--
Regards,
Tom Ogilvy

"Paul" wrote in message
om...
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

Bypass Workbook_Open when opening a workbook with VBA
 

Thanks Tom,

Obvious when you see it.

Have a great day. Cheers. Paul

"Tom Ogilvy" wrote in message ...
Application.EnableEvents = False
workbooks.Open "C:\Myforlder\MYfile.xls"
Application.EnableEvents = True

--
Regards,
Tom Ogilvy

"Paul" wrote in message
om...
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