title: VBA Worksheet change event bypass?
body: <p>I am fixing a spreadsheet. The programmer made a macro for each sheet to fire when the sheet is changed. This is good because it colour co-ordinates the sheet details when new information is added so I would like to keep this feature.</p>
  
  <p>I have written a macro which sorts the data and allows for removal and addition of new employees, this is in conflict with the change event macro and is causing my macro to have errors if they are both operational. </p>
  
  <p>Q. Is there a way to bypass the worksheet change event while the macro is running and then have it in place again once the macro is finished?</p>
  
  <p>Here is the code for the change event.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal target As Excel.Range, skip_update As Boolean)
  If skip_update = False Then
      Call PaintCell(target)
  End If
  End Sub
  </code></pre>
  
  <p>My macro is bringing up errors when I refer to worksheets or ranges.</p>