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!
Bookmarks