Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation list and protection
I have a validation list set up. If the cell is protected it will not let me
select anything from the list. what is the protection function that I need to check to allow me to view it. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200705/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation list and protection
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. If you want to select from the data validation list, unlock that cell before you protect the worksheet (FormatCells, Protection tab). Darrell_Sarrasin via OfficeKB.com wrote: I have a validation list set up. If the cell is protected it will not let me select anything from the list. what is the protection function that I need to check to allow me to view it. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation (List) and Protection | New Users to Excel | |||
Validation (List) and Protection | Excel Discussion (Misc queries) | |||
Validation protection | Excel Discussion (Misc queries) | |||
Validation & Protection | Excel Discussion (Misc queries) | |||
Validation & Protection | Excel Discussion (Misc queries) |