Hi,

I am looking for a VBA code that when the sheet is activated, disables check boxes based on a conditional values.

I have used form check boxes (Check Box 36 to Check box 60) and have a column of true/false vales (Y3:Y27).

What I would like is when the sheet is selected, it loops through all the check boxes and disables them if the appropriate value is false.

Thanks,

Chris