VBA: How do I allow filters to be turned on and off on a protected sheet?
<p>I have the following piece of code, which removes filters and then re-applies them from selected cells:</p>

<pre><code>Range("A10:AM10").Select

Selection.AutoFilter
Selection.AutoFilter
</code></pre>

<p>The problem I have is that when the sheet is protected and I try to run the code it errors, so is there a way of allowing filters to be turned on and off on a protected sheet?</p>