title: VB To Allow Filtering When Protecting Worksheet
body: <p>I have a Blueprism object which will protect a worksheet but leave a range of cells unprotected.
  I want to be able to filter this worksheet. The below code will add filters but you cannot select the drop down. Note range and handle are variables being passed in.</p>
  <pre><code>GetInstance(handle).Range(range).Locked = False
  GetInstance(handle).Range(range).EnableAutoFilter 
  GetInstance(handle).ActiveSheet.Protect
  </code></pre>