Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open question
How do I open a workbook and bypass the Workbook_Open event? I already have
code in the procedure, but I forgot to comment it out for the next open. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open question
You could throw in an
Application.EnableEvents = False before you open the workbook and then Application.EnableEvents = True afterwards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open question
Application.EnableEvents = False
Workbooks.Open "C:\MyFiles\MyFile.xls" Application.EnableEvents = True -- Regards, Tom Ogilvy "Sheldon" wrote in message ... How do I open a workbook and bypass the Workbook_Open event? I already have code in the procedure, but I forgot to comment it out for the next open. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
workbook_open | Excel Programming | |||
Workbook_Open Question | Excel Programming | |||
Help with Workbook_Open | Excel Programming | |||
Workbook_Open event and combobox state storage question | Excel Programming |