Code criteria for multiple "daughter" checkboxes in order to checkmark "mother" checkbox..

[kombatwombat53]

I have a spreadsheet with 5 ActiveX Control check boxes. I want to use the first 4 check boxes to mark steps off in a procedure. Then I want to use the fifth check box to lock the other four check boxes so they don't get accidentally selected or de-selected. In other words, one has to check or un-check the fifth check box in order to check the other four. I have successfully done this with one check box protecting another check box, but not with multiple check boxes. Any advice would be greatly appreciated. Thanks!

[Kaper]

try code for fifth box:

Please Login or Register  to view this content.

[kombatwombat53]

Works perfect! Thank you Kaper! I have never seen an "If not" statement before. Interesting. Thanks again!!

[Kaper]

The statement is

Please Login or Register  to view this content.

checkbox returns boolean
not is just negation
so the code is equivalent to

Please Login or Register  to view this content.