Data Validation Question

I have a Data Validation Drop Down menu that I want the user to only be able to pick the items in the drop down menu.

If I type something that is different I have a "STOP" message and it wont let the user put that option, but for some reason they are able to copy and paste something different than what is in the drop down bar.

Is there any way to prevent this from happening?

Thanks!

Good afternoon bgrish3

John Walkenbach has a rather clever solution here : http://spreadsheetpage.com/index.php...s_not_deleted/

He also gives a rather nice commentary as to how it works.

HTH

DominicB

Awesome thanks!