Formulas not affected by sort?

[srpd]

I’ve been told there’s a code of some type that will keep formulas and
associated charts in place even if the spreadsheet is later sorted by someone
else. Can someone walk me through how to do this?

We’re using Excel 2007.
Thanks!