protected linked cell

[ranswert]

I have a checkbox linked to a protected cell so I can't change the value in
it. How do i get it to work without unlocking it? I don't want it to be
selected when sheet is protected.

 

[Per Jessen]

I have a checkbox linked to a protected cell so I can't change the value in
it. How do i get it to work without unlocking it? I don't want it to be
selected when sheet is protected.

Hi

Unprotect the sheet from the macro, pass the value, then protect the sheet
again.

sheets(1).unprotect Password:="Pass"
range("A1").value=me.checkbox1.value
sheets(1).protect Password:="Pass", DrawingObjects:=True, Contents:=True,
Scenarios:=True

//Per

 

[ranswert]

Is there another way to do this without having to protect and unprotect the
sheet each time the checkbox is checked.