Thread: Function to a value in check a list

Originally Posted by teylyn

I can't verify that. A locked cell with list validation can not be changed when the sheet is protected (tested in XL 2010). Can you explain how to achieve what you describe?

In Excel 2004,
I selected C1 and set Validation to List with the source A1:A10. I verified that C1 is Locked

After I set Sheet protection, I was able to change C1 by selecting from the list.
When I tried to type an entry into the C1, rather than selecting form the list, the Sheet Protected message prevented me from entering the data.

It must be a special feature of 2004.

Looks like it , because it does not work like that in 2010