Difference between manual "click" of activeX checkbox and coded "click"

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?

OnErrorGoTo0 - thank you so much for your reply. Sorry for my confusion but I am not quite sure I understand your recommendation. What is the value of blnSkipEvents? Your If statment isnt comparing it to True or false.

To further example what I am looking for:
I have (2) sections on Sheet 1 and both sections have checkboxes. Section 1 has (4) checkboxes (1-4) and Section (2) has (19) Checkboxes (5-23).

Currently if #1,2, or 4 checkbox in section 1 are clicked (either manually or using code) - I have numerous events trigger and certain checkboxes in section 2 change automatically (mainly #5-9).
I would like that if 5-9 is changed by coded (such as the clicking of 1,2,&4) - then the events are triggerd as nornal. BUT if 5-9 are changed manually to not do "those events" but to do something else.

I would like to write code for each click of checkboc 5-19 - I just dont want the clicking of 1,2,&4 to trigger those events.

I am sure your recommendation probably does that as you always seem to be able to help me out - but I just dont understand it.

Okay - I really appreicate your willingness to help on this matter so thank you. I still havent figured it out. I have uploaded a sample sheet to further explain my problem. I think I have captured it correctly (I hope).
Current code:

Please Login or Register  to view this content.

Desired:
When CheckBox 2 is changed via code or manual ,to true then 3 & 4 are always true.

When 3 or 4 are MANUALLY "changed" to EITHER TRUE or FALSE then 1 is true and 2 is false - BUT currently when 3&4 are changed from checkbox2 event, those events of making 1 true cannot happen. Only when 3&4 are manually clicked is 1 = True.

When 1 is changed via code or manual, to true then 2 is always false.


The problem lies within this:
Currently, when 2 is changed via code to True, 3 & 4 change to true which is correct. BUT that then triggers 3 & 4 event changes which changes 1 to true, which changes 2 back to false which negates the first change of 2 to true.