That's one of the weaknesses of data validation -- users can paste any
value into the cell, and overwrite the validate settings.

Perhaps you could use programming to validate the data.

Antonio Guillen wrote:
The content of a cell can be copy into a cell containing a pick list in a
Password protected sheet;
That shouldn't be; how can i prevent that?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html