title: Run VBA code and keep Excels UNDO/REDO intact?
body: <p>I run this code to force update a few charts:</p>
  
  <pre><code>'Force update charts
  For Each cht In Sheets("Charts").ChartObjects
      cht.Chart.SeriesCollection.Add Source:=Worksheets("Builder").Range("AI2:AI7")
      cht.Chart.SeriesCollection(cht.Chart.SeriesCollection.Count).Delete
  Next cht
  </code></pre>
  
  <p>I never want to undo or redo the lines below from the Excel quick access bar. Unfortunately the  lines above clear Excels undo/redo list and I can no longer undo/redo changes.</p>
  
  <p>Is it possible to make Excels undo/redo ignore the VBA code that runs and not be cleared?</p>