Now ... If I open Book2 first (which has Application.EnableEvents = False),
then open Book1 (which has Application.EnableEvents = True), then why ALL
events in both Book1 & Book2 become also disabled ?

And, if I move the above Aapplication object from ThisWorkBook open event to
a Worksheet event, would this make any differenece on how it's treated?

Thanks again.


"monir" wrote:

Chip & Doug;
Thank you very much for the clarification.


"Doug Glancy" wrote:

monir,

Properties of the Application object, such as EnableEventsand
ScreenUpdating, apply to all of Excel, i.e., they are global.

hth,

Doug

"monir" wrote in message
...
Hello;

Book1.xls and Book2.xls, each has few events.
For editing purposes, if I open Book1 (which has Application.EnableEvents
=
True in its ThisWorkbook Open event module), and then open Book2 (which
has
Application.EnableEvents = False in its ThisWorkbook Open event), ALL
events
in both Book1 and Book2 become disabled !!!

Is this how it supposed to work ???

Thank you.