Locked check boxes and option buttons

[tweek]

I have a sheet that i´m trying to protect and allow users to edit certain ranges, when doing so I can´t unprotect check boxes and option buttons. The cell that they are placed in are unprotected and so are the cells linked to the check boxes and option buttons.

Even if I allow to edit the whole sheet as an range I still can't click those boxes without getting the protection warning.

Any ideas?

Thank you.

 

[patele]

Not sure if I fully understand what it is you're trying to do. If the cells linked to the check boxes and option buttons are unprotected you can use the following vba.

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
ActiveSheet.Protect
Else If CheckBox1.Value = False Then
ActiveSheet.Unprotect
End If
End Sub

For Option Boxes just replace CheckBox1 with OptionBox1. You may also have to change the number depending on what yours are.

The code goes on the sheets you plan to use it on. Click on the sheet tab, then view code.

Let me know if this helps.

 

[tweek]

I found a general solution before this one was posted. I was only trying to use option buttuns and check boxes in a protected sheet but it kept locking those boxes and buttons too. My solution was to select those check boxes, option buttons and the linked cells and go to HOME --> CELLS --> FORMAT--> LOCK CELL. And then do the standart Allow users to edit and protect the sheet. Somhow that unprotected the buttons and boxes