title: "Undo" history button clear after run macro excel
body: <p>I have a macro that fires on the <strong>"Worksheet_SelectionChange"</strong> event. The macro validate data of one column, it changes the background color of the cell if its wrong.</p>
  
  <p>The problem is after run the macro, it clears the history of changes (Ctrl Z) of all the document, even the history changes of other cells that I didnt validate.</p>
  
  <p>How can I solve this problem?</p>
  
  <p>Thanks.</p>