| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i protect a worksheet without disabling drop downs lists?
I would like to protect most of the cells on my worksheet but i have drop
down menus to provide options. However, when i protect the sheet the drop downs are locked. Is there a way around this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i protect a worksheet without disabling drop downs lists?
How did you create the dropdowns? What version of excel are you using?
If you used data|validation and xl2003 (IIRC), unprotect that cell. If you used a dropdown from the Forms toolbar or a combobox from the Control Toolbox toolbar, make sure the linked cell is unlocked. BME wrote: I would like to protect most of the cells on my worksheet but i have drop down menus to provide options. However, when i protect the sheet the drop downs are locked. Is there a way around this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
| Combined use - drop-downs, filters, protect sheet | Excel Worksheet Functions | |||
| Copying named lists used in drop downs from one workbook to anothe | Excel Worksheet Functions | |||
| disabling readonly(protect on worksheet) using vba | Excel Programming | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Linear Mode
