Application.EnableEvents ... Is Local or Global ?
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.
|