Option Box Run Time Error Cell Locked

H

harksteve

I have created option boxes that work great thanks to this forum. M
problem is when I enable "sheet protection" and click on the option bo
I get a run time error that says "the cell is locked." I have formate
the cells in and around the option box as "not locked" and then enabl
sheet protection.
Is this the result of some property in visual basic?

Thanks in advanc
 
B

Bob Umlas

The cell the option box(es) are linked to is the culprit - you need to have
this cell unlocked.
If you also want it hidden, hide the column or format the cell as ;;;
Bob Umlas
Excel MVP
 
H

harksteve

Thanks Bob,

These unlocked cells still contain data which is both necessary to the
user
yet vulnerable to accidental overwrite? Is there a solution to this
problem?

Thanks again
 
D

Dave Peterson

Maybe you could put the cell in a hidden column/row. Or put it on a hidden
worksheet.
 
Top