Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I have a WorkBook_BeforeClose event procedure in which in a special case I want to set Application.EnableEvents = false before a Thisworkbook.Close statement in order to avoid re-calling the WorkBook_BeforeClose event procedure. It works, but when next time opening the workbook Application.EnableEvents = false, and I cannot automatically reset it to True (e.g. in a WorkBook_open event procedure) because the False setting prevents executing the WorkBook_open event. How can I get out from this circulus vitiosus? Thanks, Stefi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.EnableEvents | Excel Worksheet Functions | |||
application.EnableEvents | Excel Discussion (Misc queries) | |||
application.enableEvents | Excel Programming | |||
Application.EnableEvents | Excel Programming | |||
Stopping the use of enableevents | Excel Programming |