Forum Discussion
DanMcG
Jul 21, 2022Brass Contributor
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...
- Jul 21, 2022Turns 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.
DanMcG
Jul 21, 2022Brass Contributor
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.
DanMcG
Jul 21, 2022Brass Contributor
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.