Disallow Pasting over Validation

  • Thread starter Thread starter Jeremy
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing copy/paste on validated cells 2
Controlling User Input 2
Data Validation/Cell Protection Question 2
how do you restrict the users from copying and pasting 1
Protect validation but allow drop down selection 1
Data Validation on Locked Cell 2
Protect Data validation cells from copy paste 3
How to prevent Cut&Paste to change style and data validation on protected sheet 1

Back
Top