The default is true until a VBA command sets it to False. It remains False
until another VBA command sets it to True! Therefore once it is set to False,
you MUST use Application.EnableEvents = True! You can issue this command
anywhere you want (in a normal module, Immediate window) EXCEPT in an event
Macro (because it will NOT run until EnableEvents is not set to True in an
other way)!

Regards,
Stefi



€žRobin Clay€� ezt Ã*rta:

"Stefi" wrote:
I'm afraid you have no other choice than launch Excel without opening any
workbook, reset Enableevents as I told you and THEN open your workbook.

I guess there must be a way, somehow, to set EnableEvents = True as the
default ?

Thanks for writing.