The existing custom toggle makes it easy for me to both turn off Events and visually see if they are currently off or not – see the over/under pictures of my Ribbon when the button is clicked below. Yesterday, I was working on a macro that erred out, after the line
When I used my ribbon button to re-enable events, it reversed the orange highlight in the picture from highlighting it when it was off, to highlighting when it was on – see the second picture.
That made me think it would be handy to use the custom toggle button as a primary Events status indicator and not just a switch – so that I could always tell when Events were disabled. Rather than using “Application.EnableEvents = False” in my code, if I could trigger the Ribbon code using something like:
But I haven’t been able to make it work. I’m researching your “public” comment, but at the moment I’m not completely sure what I would need to do, although that does make the error I’m getting make more sense – third picture below.
Let me know if you have any questions. Thanks for your help.
Bookmarks