Is there a way to trick excel in knowing the different between an actual user manual click of a check box and when its changed programmatically?
There are many many instances in my code where I change the value of other checkboxes located in other sheets and I have events that run when those checkboxes are clicked.
But there are times when I dont want those events to run when the user manuals clicks the checkbox and times when I do.
For example, I would like to have happen that when checkbox5 is MANUALLY clicked by the user, that a certain event runs, but if the value of checkbox5 is changed from other points in the code (programmatically) - I do not want that event to run.
Is this possible?
Bookmarks