VBA for unlocking numerous form control checkboxes

[petespec]

When I lock my worksheet, the form control checkboxes can't be checked or unchecked, even when the cells they are in are unprotected. However I can when the actual checkbox is unprotected. Just takes too many steps (rt click the checkbox, open form controls, uncheck the "locked" in the protection tab) to do this to all 973 of them in the C23:C1000 range. Looked far and wide for a macro that would do this, but not successful. Even tried modifying a few similar macros, still no success. I have been able to modify numerous other macros to work as needed, just don't have the programming skills to figure this one out. I would appreciate any help anyone can offer. Thanks

 

[AlphaFrog]

[color=darkblue]Sub[/color] UnlockCBs()
    [color=darkblue]Dim[/color] cb [color=darkblue]As[/color] CheckBox
    [color=darkblue]For[/color] [color=darkblue]Each[/color] cb [color=darkblue]In[/color] ActiveSheet.CheckBoxes
        cb.Locked = [color=darkblue]False[/color]
    [color=darkblue]Next[/color] cb
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

 

[petespec]

[COLOR=darkblue]Sub[/COLOR] UnlockCBs()
    [COLOR=darkblue]Dim[/COLOR] cb [COLOR=darkblue]As[/COLOR] CheckBox
    [COLOR=darkblue]For[/COLOR] [COLOR=darkblue]Each[/COLOR] cb [COLOR=darkblue]In[/COLOR] ActiveSheet.CheckBoxes
        cb.Locked = [COLOR=darkblue]False[/COLOR]
    [COLOR=darkblue]Next[/COLOR] cb
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]

Thank you so much! That worked perfectly.