Undo history

[Guest]

Is there a way to access the undo history in a macro? It would be very
helpful in triggering code based off of specific user actions (such as
inserting a new row in a sheet). Thanks in advance for any help you can
provide!

 

[NickHK]

AFAIK, there is no Excel method to get this history. You could see if the
Edit>Undo menu item is enabled and if so read the undo action, but you could
not tell which range/object had been affected unless you also maintained a
list of activecell, selection etc. IMHO it would be difficult to keep
correct.
Also macro actions wipe out the history, so your reaction in code would
clear all undos .

NickHK