Checkbox is true automatically

[Sanjibghosh]

Hi All,

I need help. Once all Checkboxes under Activity column are clicked (means true) then Project Concept & Initiation checkbox (under Project column) is true automatically. Can it possible? If possible, then please help me how to do it?

[mjr veverka]

Maybe that way ?
A highly imperfect way, but try ...
Run this macro and observe the "C:D" columns (auxiliary columns) and defined names in the workbook.

Please Login or Register  to view this content.

But if you select checkbox "Project Concept & Initiation", the control formula '= FALSE_TRUE' will be overwritten in cell 'D1' and you will have to recreate it.
You can delete the macro afterwards.

[Sanjibghosh]

Hi porucha vevrku,

I am trying this code but not working. Can you do it on my file? then it will be very helpful for me

[mjr veverka]

After using the macro, formulas in 'C1:D4' cells can be masked in white.
Below mp4 (definitely compatible with mpc-hc) with "instruction".