The cell with the DV needs to be unlocked as well. You cannot change a value
in a cell without having access to change the cell contents, i.e: through a
list in DV.
--
John C


"sign guy" wrote:

I want to protect a worksheet that uses drop down list boxes. I want to
allow the user to select from the list box but not access the other cells in
the worksheet.
When I protect the worksheet, unlocked cells can be accessed ok. But, the
drop down list boxes will not work.

Any way to correct this problem?
Thanks.