Users overwriting cells with Validation set to "Lists"

  • Thread starter Thread starter Mack Neff
  • Start date Start date
M

Mack Neff

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
 
This is the Error Check formula
=IF(ISBLANK(E3) , FALSE,
IF (D3 = $A$3,
ISERROR(MATCH(E3, $A$7: $A$10, 0)), The location of the list
ISERROR(MATCH(E3,$A$13:$A$16,0)) The location of the list
This is an error check formula should you need it?
 
List is checked and a list name was provided.
One can not type anything into the cell that is not on the list, but "Paste"
will overwrite the Validation

Mack
 
Back
Top