Using drop down lists on protected worksheet

S

sign guy

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.
 
J

John C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting sheets with drop down boxes 6
Filtered drop down list 2
Expanded Drop Down Box Question 2
Create Drop Down Box populated by a List 1
how to delete drop down boxes 2
drop down list 2
How to change format protection default to unlocked? 2
Enabling Autofilter and Sorting in a Protected Sheet 2

Top