OK, let's go back to basics. I need to understand how you got to where you
are.
- Did you first enter formulas, then create Data Validation [DATA
VALIDATION ALLOW LISTS SOURCE.... ] then protect your worksheet?
- Does the formula you talk about reference the cells used in LISTS SOURCE ?

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Dolores Gomez" wrote:

Hi Gary,

If I unlock the cells that have the validation (I also have a function in
the same cell) there is a chance that they will delete the function and I
only want them to have the option to click on the drop down box.


"Gary Brown" wrote:

Unlock the cells that have the data validation.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Dolores Gomez" wrote:

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.