Most macros that do anything destroy the undo/redo stack (along with the
clipboard).

If you want to control an undo, maybe you can take care of it yourself.

Check out John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip23.htm

pk wrote:

Hi there,

I've found that calling Application.OnUndo method clears all the Undo
history, so this method appears unuseful. Maybe there is a way to keep the
history and use Application.OnUndo method only to place custom Undo method on
the top of the Undo stack?
More over if I call Application.OnUndo in OnUndo handler, it doesn't place
new handler on the stack.

--

Dave Peterson