Forum Discussion
Solved
Application.EnableEvents is getting turned off by some rogue process
So been having this problem where my code wasn't being saved once i exited the workbook or excel. then it dawned on me to create a proc that used OnTime to run every second and check to see if Enable...
- Turns out it was one of the commercial addins. emailed the founder and am awaiting instructions. going to close this as i know what is causing the issue.
so one quick note, i changed the print line to this: Debug.Print "Enable was turned off at " & Format(Now, "hh:nn:ss")
and can see where this is being turned off every 5 minutes (to the second). so one of my commercial addins is probably doing this. will start by disabling both addins (MZTools and AutoMacro) and then maybe Rubberduck once that is done. but getting closer to the Why question being answered.
and can see where this is being turned off every 5 minutes (to the second). so one of my commercial addins is probably doing this. will start by disabling both addins (MZTools and AutoMacro) and then maybe Rubberduck once that is done. but getting closer to the Why question being answered.
- Turns out it was one of the commercial addins. emailed the founder and am awaiting instructions. going to close this as i know what is causing the issue.