Thank you, Tom.

In the link you provided, the approach actually undo one backward step
only. After one undo, the undo button becomes disable, and there is no way to
undo backward further with the undo button.

On the other post, the procedure sounds also can only undo one step back:
http://groups.google.com/group/micro...b6edcdc 3a25b

"Tom Ogilvy" wrote:

No built in support for it - you have to do the work. Here is one approach:

http://j-walk.com/ss/excel/tips/tip23.htm
John Walkenbach's site.
--
Regards,
Tom Ogilvy


"Zhu" wrote in message
...
Hello!

After we change cell values with our micro procedures, we can not use the
undo button to resume previous values.
How can we undo changes made by our micro procedures, as if the changes
are
made in excel spread sheet by hand?

Thanks!