How can I use auto filters when the worksheet is protected? I have a
worksheet that I want co-workers to use, however I have formulas in certain
ranges that I don't want unwitting co-workers to change. The problem is when
I protect the worksheet, the auto filters at the top of the columns become
unusable. How can I protect the range of formulas and use the auto filters
at the same time?

I have looked in the help index for excel and can't find the answer.
Anyone's advice would be greatly appreciated.