I have used data validation quite a bit, but have never come across this.

In a worksheet, I have validation on a number of cells, most are using range
validation and I just entered a list validation.

My range validation works fine, but my list one does not because the error
check won't work. The list appears ok, but users can overtype a value
(which I don't want). I have entered "stop" works, but the error checking
doesn't. I selected "stop" for the alert and checked off the "show error
message". Fyi, the list is a named range on another worksheet.

Is there a limit to the number of values that can be validated? I have
approx 1000.

Thanks for any help