View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sign guy sign guy is offline
external usenet poster
 
Posts: 1
Default 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.