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