Allow Excel to undo macro actions
I understand that not every macro is undoable, but some should be. For example, "Selection.Interior.Color = 255" is not undoable at the moment, but should be since you could do the exact same thing from the Ribbon. This really discourages people from using the macro recorder, or even macros in general.
This VBA integration with the undo stack is not something that we’re planning on doing (see the idea about bringing VBA into the modern world).
7 commentsComments are closed
Is now February 2019 - Any chance that VBA Integration with the Undo Stack is on the roadmap or in Development? Workarounds are extremely lengthy (codewise) and complicated.
MS, why would there not be an "Undo" button ?
An ancient problem that Microsoft will never fix.
Aaron Schultz commented
Macros and add-ins nuke the undo stack. Either fix this or add an API to allow user code to fully recover it.
Ryan MacGregor commented
Excel has been this way forever, and it makes no sense. You can undo macro operations in Word and PowerPoint, but not Excel. I would love to hear from Microsoft why they refuse to address this critically important and longstanding deficiency.
This feature request strangely has only 16 votes at this time, which really understates the importance of this problem to add-in developers and their vast user bases. This is by far the #1 feature request and most documented deficiency for Excel you will find outside of UserVoice.
Daniel Smith commented
In excel ANY VBA procedure which modifies a worksheet has a side effect of clearing the undo stack. Provide a vba interface to the excel undo functionality so it is possible for a VBA procedure to preserve the undo stack and add its own undo / redo methods.
Anthony B commented
This is an ancient bug and an ancient request.
Undo should be implemented beneath the macro layer.
There is some undo events available but they are completely useless.