How do I restore Excel's undo history after running a macro?

[mdelia1]

I'm a VBA newbie, but managed to implement (aka copy) a macro that adds a time/date stamp in Column A when any of the subsequent cells in that row are changed. With this now working, I really need the ability to restore the undo history in case a change to the data needs to be reverted. Thanks!Sub procedure:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
Application.EnableEvents = False
For Each c In Target
If c.Column > 1 And c.Column < 21 Then
Cells(c.Row, 1) = Now
End If
Next c
Application.EnableEvents = True
End Sub

 

[adam087]

Hi mdelia. Welcome to the board.

I was looking in to this closely t'other day for an unrelated post and the general consensus is there is no way of maintaining or restoring the undo stack after a macro has been run. There's some more reading on same here...
Preserving the Undo List (Microsoft Excel)
Excel Developer Tip: Undoing a VBA Subroutine (this is pretty hardcore, above my level)

Hopefully someone else will jump in here and prove me wrong but the evidence seems pretty overwhelming.

Sorry

/AJ

 

[Michael M]

Adam is correct, the Undo stack is cleared once a macro has been run...and cannot be recovered.

 

[Megan2682]

Thanks for the info guys