Using drop down lists on protected worksheet
I want to protect a worksheet that uses drop down list boxes. I want to
allow the user to select from the list box but not access the other cells in
the worksheet.
When I protect the worksheet, unlocked cells can be accessed ok. But, the
drop down list boxes will not work.
Any way to correct this problem?
Thanks.
|