protecting controls

[Mike Beebe]

I have checkboxes in cells (technically over but not in the cell) that even
though protected and the sheet is protect, the user can still can
check/uncheck the checkbox. How can I control which checkboxes can and
which cannot be accessed by the user?

Any thought would be appreciated.

 

[JE McGimpsey]

I have checkboxes in cells (technically over but not in the cell) that even
though protected and the sheet is protect, the user can still can
check/uncheck the checkbox. How can I control which checkboxes can and
which cannot be accessed by the user?

One way:

Enable/disable the checkboxes using a macro. You give few details, but
if the checkboxes are named, for instance, "Check Box 1", "Check Box 2",
etc:

Public Sub EnableSomeCheckboxes()
Dim i As Long
With ActiveSheet.CheckBoxes
For i = 1 To .Count
Select Case i
Case 1, 3, 5, 7, 8, 10
.Item("Check Box " & i).Enabled = True
Case Else
.Item("Check Box " & i).Enabled = False
End Select
Next i
End With
End Sub