I have a MSForm Checkbox on a worksheet that uses a linkedcell to update a
cell on the worksheet. The sheet is protected and the cell is locked. In a
class module, when the change event is triggered for the checkbox, I
unprotect the form, and turn off enableevents. But I keep getting a cell
protected message on the linkedcell. I tried unlocking the cell in the
change event, but I still get the message and then the code finishes
succesfully.

How should I handle the lock issue? I thought about removing the linkedcell
setting and setting it in the event (it's currently set in properties of the
checkbox) but I don't have anywhere to store the cell info that I would put
in the linkedcell field.

Thanks

Steve