Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Protection fails with validation lists
I wish to protect data in a spreadsheet from accidentally being changed
so I use sheet protection with cell locking. Sure enough when I try to type directly into the cell I am prevented. HOWEVER I have setup validation pulldown lists to force users to enter valid data. If I go to a locked cell and select the pulldown list I can select another value from the list and this is entered into the cell despite the fact is locked and the sheet protected. WHY? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Protection fails with validation lists
I was able to reproduce your problem with Excel 2000 but not with Excel 2002
or 2003. So it looks like MS changed their design in later versions. The only way I know to work around this problem in Excel 2000 is to embed the list in the data validation directly. That means, instead of referencing a range in the Data, Validation dialog, place the items in the list in the dialog in place of the range, separated by commas. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 validation lists for the same value on another cell | Excel Worksheet Functions | |||
Data Validation and Cell Protection | Excel Discussion (Misc queries) | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
Share write protection fails | Excel Discussion (Misc queries) | |||
data validation and cell protection | Excel Discussion (Misc queries) |