Using drop down lists on protected worksheet
 

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.

Using drop down lists on protected worksheet
 

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.