Hi Halim,

Many macro instructions will destroy Excel's undo list. There is no way to
restore the undo list. If you wish to provide an undo facility for your
macro, you will need to add code to provide your own undo functionality.

In the suggested link, John Walkenbach demonstrates a simple undo strategy.
In his commercially available Power Utility Pak utility, John Walkenbach
provides more complex examples.

In short, however, if you require an undo functionality in your VBA
routines, invariably the onus will be on you to add code to provide such
functionality.



---
Regards,
Norman



wrote in message
ups.com...
Hi Norman,
I've tried that way... but it seems only undo once ...
How to add the existing undo action lists ... ?
thanks,

hAlim