Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Undo With Excel VBA
Deze pagina in het Nederlands

Creating An Undo Handler To Undo Changes Done By Excel VBA


This article uses techniques not available to Excel 97.

Unlike Word, changes made to an Excel workbook by using VBA cannot be undone easily. One has to write code that:

In this article I will demonstrate how one can use two class modules to create a (more or less) generic undo handler which one can plug into any project.