View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolores Gomez[_2_] Dolores Gomez[_2_] is offline
external usenet poster
 
Posts: 8
Default Protecting sheets with drop down boxes

I have an excel spreadsheet that has drop down boxes and formulas. I want to
be able to protect this spreadsheet so that other user will not delete my
formulas. I password protected the spreadsheet, however, when this sheet is
protected i am not able to select from the drop down list. Is there a macro
that I can incorporate into my worksheet that would help me with this
problem. If so, can you please give me the codes needed?

Thanks.