Password

  • Thread starter Thread starter Aslam
  • Start date Start date
Hi,
You have to protect the sheet.
Unlock all cells you want users to access, including cells with data
validation. (Format, Cells, Protection)
Then protect the sheet (Tools, Protect Sheet)
Users can now enter data, but can't change the data validation.

However, a user can still paste non-valid data into a data-validated cell,
which is really annoying. Also, when any value is pasted in this way, the
data validation is removed, despite the sheet being protected. What was MS
thinking!?

You need to use an event macro to prevent paste-happy users from wrecking
your sheet.
Regards - Dave.
 
Dave said:
However, a user can still paste non-valid data into a data-validated cell,
which is really annoying. Also, when any value is pasted in this way, the
data validation is removed, despite the sheet being protected. . . .
Click to expand...
....

Actually, you can paste plain text, possibly from other applications,
into cells with data validation and only the cell contents would
change. The data validation rules would remain as-is.
 
Hi Harlan,
But the user will often just do a regular Copy & Paste, and won't take the
time to Paste Special, Values, or even double click to paste plain text.
Dave.
 
Dave said:
But the user will often just do a regular Copy & Paste, and won't take the
time to Paste Special, Values, or even double click to paste plain text.
Click to expand...

Where I work, copying from either PDF files or other programs and
pasting into Excel workbooks is very common, and that's where data
validation most frequently breaks down.
 
Back
Top