Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
Can any body guide me that how to assign a password to data validation thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
Dave wrote...
.... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
Dave wrote...
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password | Excel Discussion (Misc queries) | |||
****Password**** | Excel Discussion (Misc queries) | |||
How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) |