Lock a Form Control Checkbox once it is checked

Maybe this...

Create a Forms CheckBox on your worksheet
Right-click and choose 'Assign Macro'
Click 'New'

It should open the VBA editor to a new module, with a new sub called something like "Sub CheckBox1_Click()". Add a little code and close the VB editor. (Adjust your sheet/checkbox names as needed, of course.)

Please Login or Register  to view this content.

Thanks. That worked.

You're welcome!