Utilizng full AutoFilter features while specific cells are protect
 

I have three worksheets going on with dynamic content between all three
worksheets (data is entered on sheet and then shows up on another sheet). I
manually protected individuals cells that contain these formulas so a person
could not inadvertently "screw things up." (Format/Protection/then clicked
"Locked"). I then activated the protection feature for the entire worksheet
(Tools/Protection/Protect Sheet).

On the top of each worksheet sheet I activated the AutoFilter function so
that each column in that worksheet can be filtered. When I click on the
AutoFilter drop down menu I am able to filter each column by the lower
options (All, Top 10, Custom, Blanks, Non Blanks) but I cannot use the two
top options (Sort Ascending, Sort Descending).

Is there a way to have the protection of formulas in individual cells and
also have the ability to utilize the full functionality of the AutoFilter and
sorting features?


The error message I receive is:
€œThe cell or chart you are trying to change is protected and therefore
read-only. To modify a protected cell or chart, first remove protection using
the Unprotect Sheet command (Tools menu, Protection submenu). You may be
prompted for a password.€�

Thanks!