View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
monir monir is offline
external usenet poster
 
Posts: 215
Default Application.EnableEvents ... Is Local or Global ?

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.