Undo buffer clears

Question

When I run a simple macro that does not include any special code for clearing the undo buffer, the undo buffer is cleared.

Is this the default for macros in Excel 2010? I have found no notation in MSDN concerning this.

Answer 1

Many macro actions clear the undo stack. Generally speaking: as soon as your macro changes any object in your workbook. There is no way to prevent that from happening unfortunately. If you want to be able to undo macro actions, you will have to write code to do so. Even then, the current undo stack is lost.

See: www.jkp-ads.com/articles/undowithvba00.asp