I am trying to create a dropbox where the user can only select from the
list. I know I can do this through data validation, but the problem is that
it can be overridden if a user paste a value on to the cell. How can I have
a dropbox where the user cannot override the validation through pasting or
through any other means?

Thanks
Leo