| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection with working dropdown lists.
What I am trying tp do is protect a worksheet but allow drop down list to
work properly. What is the best way to accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protection with working dropdown lists.
FormatProtection
uncheck Locked for your dropdown cells HTH -- AP "Chaltain" a écrit dans le message de news: ... What I am trying tp do is protect a worksheet but allow drop down list to work properly. What is the best way to accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protection with working dropdown lists.
I don't think so, it's work. I also facing this problem. I uncheck locked my
dropdown cells, still could not open dropdown cell. JOHN "Ardus Petus" wrote: FormatProtection uncheck Locked for your dropdown cells HTH -- AP "Chaltain" a écrit dans le message de news: ... What I am trying tp do is protect a worksheet but allow drop down list to work properly. What is the best way to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| Help Please with Dropdown lists and Vlookup | Excel Discussion (Misc queries) | |||
| Excel - need a function to compare lists | Excel Worksheet Functions | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| In-cell dropdown for validation stopped working | Excel Worksheet Functions | |||
Linear Mode
