The 2nd option: I do not want others to change the choice I placed in the
drop down list. I highlighted the cells that contain teh list and they are
already protected and then when I protect, I can still change the drop-down
list from one choice to the other. Any ideas?

"Springbok" wrote:

Not sure what you mean by "change". Do you mean that you can change the list
(i.e. delete existing values, insert, modify etc...)?

Or do you mean that you can still select the item from the drop down list
and you want to restrict users from using the list?

If the first, then I don't understand why because when the list is 'locked'
and the sheet protected, I don't seem to be able to amend it.

If the second, then make sure you are locking the cells that the validation
is applied to.

Let me know what happens.
Cheers,
Jon

"kfutbol" wrote:

It is a validation and uses a list on the same sheet
(Data-Validation-Lists-Select Cells). I highlighted the list and selected
Format-Cells-Protection Tab-Lock and then I protected the sheet, but I can
still change the drop down list. What am I doing wrong?? Thanks.

"Springbok" wrote:

Hi,

Is the drop down list part of validation / combo box? If it is is it linked
to a list in an array in the same workbook? You can protect it by locking
the cells that make up the list array. Then apply worksheet protection.

Cheers,
Jon

"kfutbol" wrote:

When protecting a sheet, I know you can prevent changes to cell content but
how can you prevent a change in a drop down list? Once I protect the sheet,
I can still change a drop down list. How can I prevent this? Thank you!