Hi all,

I have a spreadsheet that uses worksheet activation to run a few small macros, but the problem is that after I switch sheets, the macro for the activated sheets runs, but then the application.EnableEvents value mysteriously changes to false. so far I have tried the following fixes:
- Turned off macro security. no change
- put a watch on Application.EnableEvents to break the code when the value changes..no code break, and the value still changes to false.
- I tried adding the line Application.EnableEvents=True as the last line in every macro...It still goes false
the only way that I can get the spreadsheet to still function is to open the immediate window and type "application.enableevents=True" at every step.
Any ideas??