Is it possible to capture an Undo event?

[Joe]

Hi all,

I have checked the event lists for both document and application, searched the forums and the web, but seems like this question hasn't really popped up yet.

Is it possible to detect when the user has used an Undo? I have a while loop running that in some cases may base the result on the amount of actions the user has taken, thus an Undo throws the sequence.

If it were possible to intercept the Undo happening I could store the number of actions in a global, subtract on Undo and use that to determine what to do during the loop.

Any ideas?

[shelbym]

:-( There really isn't any support for the Undo stack in VBA, you are pretty much limited to rolling all your commands into one Undo, and being able to call Undo. Other than this, not much is there.

I agree, capturing when Undo is called would be great, or being able to skip steps and the like. :-)

-Shelby

[ddonnahoe]

Shelby, correct me if I'm wrong, but couldn't you capture the CTRL+Z keystroke? This wouldn't take into account the user clicking the undo icon on the tool bar, but it would be a start. Maybe find a way to disable the undo button and only allow CTRL+Z?

[Joe]

Another option would be to implement an undo button in the macro/docker interface, but neither of these options are universal enough which should be the aim for a proper product...

Currently I have "overcome" this by adding a warning to the manual.