Error message after protecting worksheet

[Wellie]

I have a worksheet with a range of cells needed to be
protected and another set unprotected to allow user to
enter data. In this set of unprotected spreadsheet, I
have a few cells using a Combo box to allow user to
select data from and then place the selected data into a
cell. I followed the usual steps to unprotect cells
(togeter with the combo boxes by selecting them at the
same time) by enter the range of cells as "Allow users to
edit ranges".

The problem I have is that Excel prompts me an error msg
comlaining "The cell chart you are trying to change is
protected and therefore read-only" when I click the combo
box to select data.

I click OK on the error message. The selected answer
shows up on the combo box but NOT on the cell where I'd
like the result to be placed by the combo box. I checked
the range of unprotected cells where the answer should
be, those cells are wihin the range of unprotect cells.
The selected answer should be able to be placed in those
cells.

Can someone please help how can I solve this problem ?

Thanks in advance.

 

[Jim Rech]

I believe the "Allow users to edit ranges" feature permits only direct user
entries, not indirect by a combo box.

I think you're going to have to remove the cell's Locked state via Format,
Cells, Protection in order to use it as you want.