Topic: VBA Excel: Rollback of changes of a macro?
It appears in Excel it is impossible regular means to roll away change made a macro on CTRL+Z
Esteemed forums, all get out on a miscellaneous. As can. Someone does book sheets who that remembers an array of cells and then recovers them...
As it seemed to me - I got out also: before change I remember cell contents + I conduct the counter of the remembered elements.
Read that that on CTRL+Z it was possible to make rollback of changes, it is necessary to interpose the code in the end of a changing macro:
Application. OnUndo "a canceling of changes", "ActionUndo"
, Where ActionUndo - procedure doing a canceling of changes.
At me it turned out. But a problem that the canceling of actions works only once.
For example, if rollback of changes to make on button click all works on hurrah. And on CTRL+Z - only once.
Prompt, it I somewhere did not watch or so it and is?