Combobox problem in protected sheet
 

Here is the my problem;

I have protected sheet and some cells are set to unprotected. I am using
Combobox to get data another sheet form the same workbook. When I choose
another value from the combobox, I got an error suggesting to unlock the
sheet then make slection. BTW, the target cell is unprotected. The
unprotected cells does accept keyboard entries, but not ComboBox changes.

I am using Excel 2002.

Any help would be grateful.