How to filter a protected cell while still protecting formulas in certain columns

[nickp20]

Is there a way to filter columns of a protected worksheet while still protecting the formulas in specific cells? I want to allow other users of the worksheet to be able to filter the data, but I do not want to allow them the ability to accidentally change the formulas.

 

[Fluff]

When you protect the sheet make sure you check the "Use Autofilter" box

 

[nickp20]

When you protect the sheet make sure you check the "Use Autofilter" box

I have the "Use Autofilter" box checked, but it is still not allowing me to filter.

Thanks.

 

[nickp20]

When you protect the sheet make sure you check the "Use Autofilter" box

Is there another way around this issue?

Thanks.

 

[Fluff]

Did you apply the autofilter before protecting the sheet?

 

[nickp20]

Did you apply the autofilter before protecting the sheet?

Yes

 

[Fluff]

In that case you should be able to filter the data. Although you might not be able to use the autofilter sort.