Instead of disabling events, use a public variable

At the top of the thisworkbook module

Public bBlockEvents as Boolean

in the Beforeclose event at the top put in a line

if bBlockEvents then exit sub

then where you have the disable events statement replace it with

bBlockEvents = True

It should loose its value (become false) once the workbook is closed so you
won't have a problem on reopening.

--
Regards,
Tom Ogilvy


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