This started out with the simple "are VBA macros and undo compatible", which they mostly aren't. https://www.excelforum.com/excel-pro...o-problem.html Though I did not say so in the thread, I suspect that someone with enough ambition could build their own undo handler to overcome this problem. Well, the OP found an example of an elaborate undo handler online and wants to adopt it into his/her project. The VBA is well beyond anything I can follow (with its use of classes and such). Anyone want to step in and help out here?