Is the data so wide and varried that it rules out the use of data validation?
------------------------------------------------------------------------------------



wrote:

I have a protected sheet where the protect properties I have set allow users
only to select unlocked cells. However users can change the formulas of
locked cells by ragging unlocked cells which the locked cells reference.

Can I stop this?

Thanks in advance.