"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