| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list in a locked cell
When a cell, with a dropdown list in it, is locked, why does it let you
select the down arrow and make a selection only to then tell you that the cell is locked? Is there a way to lock the cell with the dropdown in it and not let you click down and make a selection? My validation list is complicated and I'd rather not put it into code. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown list in a locked cell
maybe put a red border around it to remind people not to click in it.
Or in the cell next to it enter: Don't click on this cell== "Susie W" wrote: When a cell, with a dropdown list in it, is locked, why does it let you select the down arrow and make a selection only to then tell you that the cell is locked? Is there a way to lock the cell with the dropdown in it and not let you click down and make a selection? My validation list is complicated and I'd rather not put it into code. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown list in a locked cell
ToolsProtectionProtect Sheet.
Uncheck "select locked cells" so users cannot select that locked cell. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 13:58:00 -0800, Susie W wrote: When a cell, with a dropdown list in it, is locked, why does it let you select the down arrow and make a selection only to then tell you that the cell is locked? Is there a way to lock the cell with the dropdown in it and not let you click down and make a selection? My validation list is complicated and I'd rather not put it into code. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown list in a locked cell
Perfect Gord, thank you!
"Gord Dibben" wrote: ToolsProtectionProtect Sheet. Uncheck "select locked cells" so users cannot select that locked cell. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 13:58:00 -0800, Susie W wrote: When a cell, with a dropdown list in it, is locked, why does it let you select the down arrow and make a selection only to then tell you that the cell is locked? Is there a way to lock the cell with the dropdown in it and not let you click down and make a selection? My validation list is complicated and I'd rather not put it into code. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select dropdown list dependant on value of a given cell | Excel Discussion (Misc queries) | |||
| Change the length of the dropdown list used to cell entries | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| How validation dropdown list open when cell is picked?. | Excel Worksheet Functions | |||
Hybrid Mode
