AFAIK, there is no Excel method to get this history. You could see if the
EditUndo 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

"le_s" wrote in message
...
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!