Using drop down lists on protected worksheet

  • Thread starter Thread starter sign guy
  • Start date Start date
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.
 
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

Create Drop Down Box populated by a List 1
Protecting sheets with drop down boxes 6
Filtered drop down list 2
Fill Drop Down with List 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Expanded Drop Down Box Question 2
Change states of some checkboxes from drop-down list? 5
how to show data in another cell from a drop down box 3

Back
Top