Disallow Pasting over Validation

J

Jeremy

Hi,

Is there a way to disallow a user from pasting over cells
for which I have Data Validation set? I'm trying to
prevent user input errors and I've successfully set
validation, but users keep pasting over the validation and
thus entering incorrect data.

Any help is greatly appreciated.

Jeremy
 
B

BrianB

If you have a dropdown list in your data validation cells you can forma
the cell as locked and protect the sheet. The user can still selec
from the dropdown
 
Top