title: Excel VBA macro to track changes in separate sheet
body: <p>I am trying to write a VBA macro to track changes to a workbook in a separate sheet.</p>
  
  <p>If you do this manually, the sequence of commands is Tools > Track Changes > Highlight Changes, taking the option Separate Worksheet. You have to do two iterations of the command, one to activate tracking inline, a second to move the tracking to a separate sheet.</p>
  
  <p>Using the macro recorder, I got to this piece of code:</p>
  
  <pre><code>With ActiveWorkbook
      .Save
      .KeepChangeHistory = True
      .HighlightChangesOptions When:=xlAllChanges
      .ListChangesOnNewSheet = True
      .HighlightChangesOnScreen = False
      .Worksheets("History").Select
  End With
  </code></pre>
  
  <p>When I run this, I get the error <em>HighlightChangesOptions method fails</em>. Any suggestions?</p>