| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| link two cell from two workbook bypass password | Excel Discussion (Misc queries) | |||
| excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
Linear Mode
