Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |