If you are getting that error message, then you didn't unlock the linked cell
before protecting the sheet. For each combobox:
- select its linked cell
- right-click and select Format Cells
- on the Protection tab, make sure Locked is unchecked
- click OK

Hutch

"Renee" wrote:

Not really. So here's my next challenge question. Is it possible, and if
so, how, to link the combo box in its properties to a cell in another
worksheet in the same workbook?

Here's what I've got: I've got two combo boxes that link to their own
respective cells, but when I go to protect the worksheet and then try using
the drop-down list combo boxes, I get, "The cell or chart that you are trying
to change is protected and therefore read-only...."

I'm thinking if I can put them on another worksheet, I can hide the
worksheet, but I just don't know how to do the link in the properties.

By the way, I have MS Excel 2007.

Any help would be grateful.

Thanks.

"Tom Hutchins" wrote:

If you mean a cell with a dropdown data validation list:
- select that cell
- right-click and select Format Cells
- on the Protection tab, make sure Locked is unchecked

If you mean a combobox from the Control Toolbox toolbar:
- set the Locked property of the combobox to False
- make sure the linked cell is not locked (same steps as for the data
validation dropdown above)

If you mean a combobox from the Forms toolbar:
- right-click on the combobox and select Format Control
- on the Protection tab, make sure Locked is unchecked
- make sure the linked cell is not locked (same steps as for the data
validation dropdown above)

Hope this helps,

Hutch

"Renee" wrote:

How can I protect a worksheet and still make my combo boxes work?