Preserve Excel undo stack
 

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

Preserve Excel undo stack
 

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

"Nehali Karpe" wrote:

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

Preserve Excel undo stack
 

That was meant to be
application.onUndo

"Mike H" wrote:

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

"Nehali Karpe" wrote:

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