Creating An Undo Handler To Undo Changes Done By Excel VBA
Pages in this article
Conclusion
I have demonstrated a method to add an undo handler to your project. Of course implementing this method means you will have to change existing code that performs actions that may need to be undone later.
The actions the undo handler can undo are limited to changes to properties of objects in general. Things like inserting or deleting sheets, refreshing querytables, updating Pivottables and etcetera, cannot be undone using this technique.
Download
I have prepared a download for you with example code. Find it here.
Feedback
Since you have managed to reach the end of this article, maybe you would care to write me a small message, expressing your opinion on this article?
Click here to write an email message to me.
Frequently asked Questions
What is the method demonstrated for adding an undo handler in Excel VBA?
What types of actions can the undo handler undo in Excel VBA?
Which actions cannot be undone using this undo handler technique?
What changes are required in existing code to implement the undo handler?
Where can I download example code for the undo handler?
How can I provide feedback on the article about the undo handler?
What is the purpose of the undo handler in Excel VBA projects?
Is it possible to undo changes like inserting or deleting sheets with this method?
What limitations does the undo handler have regarding Excel object properties?
How can I contact the author of the article for questions or comments?
Comments