Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Drop Down with a Protected Sheet
Hi All,
Thanks in advance for any help you can give me. I've got a spreadsheet that we're using to enter in timesheet information. Some cells are unlocked and some (with formulas that I don't want touched) are locked. I have a combobox that is activated when a user double clicks or uses Ctrl + Shift + Z, and it is designed to show with the dropdown menu already activated. The Combo box is linked to a cell that is not locked, although it displays (due to it's size) on top of cells that are locked. Everything works great. However, when I protect the sheet and trigger the combo box, it displays with the dropdown up, and no amount of clicking on the dropdown arrow will trigger the dropdown either. Further, if I unprotect the sheet, it won't perform correctly until I restart Excel with the sheet saved as unprotected. Any ideas? Thanks, Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Drop Down with a Protected Sheet
When the worksheet is protected, allow users to Edit Objects, and they
should be able to use the combobox. davy_gravy wrote: Hi All, Thanks in advance for any help you can give me. I've got a spreadsheet that we're using to enter in timesheet information. Some cells are unlocked and some (with formulas that I don't want touched) are locked. I have a combobox that is activated when a user double clicks or uses Ctrl + Shift + Z, and it is designed to show with the dropdown menu already activated. The Combo box is linked to a cell that is not locked, although it displays (due to it's size) on top of cells that are locked. Everything works great. However, when I protect the sheet and trigger the combo box, it displays with the dropdown up, and no amount of clicking on the dropdown arrow will trigger the dropdown either. Further, if I unprotect the sheet, it won't perform correctly until I restart Excel with the sheet saved as unprotected. Any ideas? Thanks, Dave -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box/Drop down box | Excel Discussion (Misc queries) | |||
Unprotect Combo Box in a Protected Sheet | Excel Discussion (Misc queries) | |||
If excel sheet protected, combo boxes won't work | Excel Discussion (Misc queries) | |||
Combo Box Drop down & Sheet Protection | Excel Programming | |||
setting up drop down combo box with VBA | Excel Programming |