K kiwimark Nov 21, 2008 #1 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.
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.
D Dave Peterson Nov 21, 2008 #2 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.
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.
C Chris Lavender Nov 21, 2008 #3 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
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
