protected linked cell
 

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.

protected linked cell
 

"ranswert" skrev i en meddelelse
...
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

protected linked cell
 

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

"Per Jessen" wrote:


"ranswert" skrev i en meddelelse
...
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