title: Run VBA code automatically after running a filter
body: <p>I've got a code written that categorizes employees along with their qualifications. In order to weed out employees with unwanted qualifications I have applied a filter to each column that titles the category of their qualification.</p>
  
  <p>I've written my VBA code in order that repetitious names and qualifications are made invisible for ease of location. However, I am unable to get the code to run automatically.</p>
  
  <p>Currently the only way I can get the code to run is by setting it to</p>
  
  <p>Private Sub Worksheet_Change(ByVal Target As Range) and then changing the value of an arbitrary cell.</p>
  
  <p>i found what I believe to be the correct solution at:</p>
  
  <p><a href="http://www.ozgrid.com/forum/showthread.php?t=72860" rel="nofollow">http://www.ozgrid.com/forum/showthread.php?t=72860</a></p>
  
  <p>But I cannot make sense of it.</p>
  
  <p>Is there a way to run this code without having to select and deselect a cell after the filter has run?</p>