Preserve Excel undo stack

[Nehali Karpe]

Hi,

Is it possible to preserve Excel undo stack after running a macro. It seems
that Excel clears the undo stack on running a macro and all the previous
operation are lost.

Any help appreciated.

NK

 

[Guest]

you can but you need to write an undo routine for your macro using
application.undo and it can be difficult.

Have a looke here

http://j-walk.com/ss//excel/tips/tip23.htm

Mike

 

[Guest]

That was meant to be
application.onUndo

you can but you need to write an undo routine for your macro using
application.undo and it can be difficult.

Have a looke here

http://j-walk.com/ss//excel/tips/tip23.htm

Mike