Password

[Aslam]

Can any body guide me that how to assign a password to data validation

thanks

 

[Dave]

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.

 

[Harlan Grove]

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. . . .

....

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.

 

[Dave]

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.

 

[Harlan Grove]

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.

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.