I have a drop down list in a cell using a validation list. The list is on the
same worksheet as the drop down list. I inputted the letters A to Z in my
list and sorted it to use as sort of an autocomplete but when I protect the
sheet i cannot use this. Can anyone help?

"enyaw" wrote:
I have a drop down list in a cell using a validation list. The list is on the
same worksheet as the drop down list. I inputted the letters A to Z in my
list and sorted it to use as sort of an autocomplete but when I protect the
sheet i cannot use this. Can anyone help?

Just like for any data input range(s),
unlock* your DV range/cells before you apply sheet protection

*Select the DV range, then click Format Cells Protection tab Uncheck
"Locked" OK

To quick select all DV cells in the sheet for the unlocking:
Press F5 Special Data validation All OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---