Combobox problem in protected sheet

O

Oguz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top