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.
|