dropdown list not working in validation

[excel5111987]

Hi,

I have applied validation in sheet no.1 in several columns and protected those columns with passowrd, but the user are not able to select list from validation in protected columns.


So, Please suggest solution so that user can select and enter list from validation in protected columns

example sheet is also attached .

[gjlindn]

I don't think you can protect cells that contain validation and also allow users to change those cell values. Validation in itself is sort of a protection, although it doesn't stop users from pasting over the validation cell. So in order for the sheet to be protected and allow selection of the validation cells, you'll have to deselect the Locked property from the cell format/Protection tab.

[FloMM2]

excel5111987,
This is what I would do:
Unprotect worksheet1, in an unused area on sheet1, place validation list.
Protect cells of validation list.
In column B, refer to validation list.

This will allow users to change value in column B, but not cahnge validation list entries.
hth
FloMM2

[martindwilson]

im losing the plot today another wrong answer

[gjlindn]

Although Martin's post doesn't specify the correct answer, it got me to rethink the issue . You can protect the cells if you allow users to edit the range using the "Allow Users to Edit Ranges" option on the Review tab of Excel 2007. That still doesn't prohibit users from pasting over the cell with values that are not in the validation list (as well as formatting change)...but at least the cell wouldn't lose it's validation.