Help Toggling "Circle Invalid Data" & "Clear Validation Circles" via a single button

I have a protected sheet that I can only activate "Circle invalid data" via VBA (activated by a button).
I was wondering if there is some VBA code that would allow me to activate and deactivate "Circle invalid data" via a single button. I am trying to use as little buttons as possible.
Is this possible?

Thanks in advance!
Joe

You need a flag somewhere to record the state of you spreadsheet.

either a cell

or the button itself.

This is the code to read and modify the alternative text of the button.

I use this to show the text, you would use the flag to control your macro.

Please Login or Register  to view this content.