I have a macro written where once you check a box it paste's a set
word into cells on other sheets. I have those other sheets locked so
that no one can edit them. The macro works when the cells are not
protected but does not work when the cells are protected. Does anyone
know a way around this? This is the code i have for the checkboxes.

'Checkbox code
With CheckBox1
If .Value = True Then
Worksheets("RENOVATION").Range("B6:E6").Value = "Leased"
Worksheets("BASE BUILDING").Range("B6:E6").Value =
"Leased"
Else
Worksheets("RENOVATION").Range("B6:E6").ClearConte nts
Worksheets("BASE BUILDING").Range("B6:E6").ClearContents
End If
End With