Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection not working for data validation lists
Hi,
When I protect a worksheet the free text cells are correctly protected. However, any cells that use data validation that allows the user to select an option from a list, are not protected. The user can alter the value by selecting a new option from the list. Does anybody know why this might be occuring please? This is for Excel 2000, and I am setting the protection programmatically. Thanks in advance for any help, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection not working for data validation lists
In Excel 2000 and earlier versions, you can change the selection in a
data validation dropdown, if the list is from a range on the worksheet. If the list is typed in the data validation dialog box, the selection can't be changed. In Excel 2002 and later versions, neither type of dropdown list can be changed if the cell is locked and the sheet is protected. This MSKB article has information on the previous behaviour: XL97: Error When Using Validation Drop-Down List Box http://support.microsoft.com/default.aspx?id=157484 wrote: Hi, When I protect a worksheet the free text cells are correctly protected. However, any cells that use data validation that allows the user to select an option from a list, are not protected. The user can alter the value by selecting a new option from the list. Does anybody know why this might be occuring please? This is for Excel 2000, and I am setting the protection programmatically. Thanks in advance for any help, Steve -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Protection with working dropdown lists. | Excel Discussion (Misc queries) | |||
Data Validation Protection | Excel Discussion (Misc queries) | |||
data validation and cell protection | Excel Discussion (Misc queries) | |||
Cell Protection fails with validation lists | Excel Programming |