Dear Zhu,

i´m sorry: after the VBA-Program has run, it is game over. Further all
previous actions in the "Undo"-list are extinguished.

It is possible to define other macros within your program to be listed as
"Undo"-Actions. (Therefor they have to be defined at the very end of the
program by Application.OnUndo "Undo : change all values" ,"MacroXX").

Best regards, Kai


"Zhu" schrieb im Newsbeitrag
...
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!