I have a worksheet that I have produced for other people to use and so do
not maintain tight control over its application after it leaves me.

I have a number of cells that have validation set to use only "Lists" and
that works fine. The problem is that if someone "Copies" something into one
of those cells, it overwrites the validation control and inserts whatever
the rebellious user wants to insert and the List no longer functions for
that cell.

What can I do to make the limitation tighter so they can't enter anything -
in any way - that is not on the list?

Mack Neff