XL2000
I enter data in a cell (A1) using a validation list. I protect the sheet making sure that A1 is locked (Format/Protection).
But still it is possible to change the cell entry using the drop down validation list!
Any solution?