Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If excel sheet protected, combo boxes won't work
Can anyone help. I have an excel sheet with protection turned on, when I do
that I can't select data in my combo box drop downs. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If excel sheet protected, combo boxes won't work
If you have a linkedcell to that combobox, make sure that it's an unlocked cell
on that protected sheet. If you used data|validation, make sure that the cell is unlocked in this case, too. kiwimark wrote: Can anyone help. I have an excel sheet with protection turned on, when I do that I can't select data in my combo box drop downs. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If excel sheet protected, combo boxes won't work
Hi Kiwimark
You need to change the format of the linked cell to Unlocked before you protect the sheet (Format cells... Protection and uncheck the Locked box) Best rgds Chris Lav "kiwimark" wrote in message ... Can anyone help. I have an excel sheet with protection turned on, when I do that I can't select data in my combo box drop downs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find doesn't work if the sheet is protected | Excel Discussion (Misc queries) | |||
Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
Add tab access to check boxes in a protected Excel sheet form. | Excel Discussion (Misc queries) | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
Pop Up dialog boxes in a work sheet | Excel Discussion (Misc queries) |