View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BME BME is offline
external usenet poster
 
Posts: 1
Default how do i protect a worksheet without disabling drop downs lists?

I would like to protect most of the cells on my worksheet but i have drop
down menus to provide options. However, when i protect the sheet the drop
downs are locked. Is there a way around this?