Is there any chance to enable UNDO/REDO with VBA workbook?

[NatanZ]

Is there any chance to enable UNDO/REDO with VBA workbook?

Thanks

[arlu1201]

Your question is not very clear....do you mean perform a UNDO/REDO via code?

[Whizbang]

Please clairfy what you mean. Do you mean you wish to be able to undo changes made by a macro? If so, then you would need to make a macro that reverses the process. As far as I know, you cannot "undo" changes made by a macro by just clicking the Undo button. Another option would be to save your workbook before you run the code, and if you don't like what you get, close out without saving. If the macro includes a save command, then make a copy of the file before you run it. Or, even better, have the macro make a backup before it does anything else.

[Andy Pope]

http://www.jkp-ads.com/Articles/UndoWithVBA00.asp

[Domski]

Various actions in Excel clear the undo/redo stack. Running a macro is one of them. I've seen a few attempts at creating custom undo functions but they can get pretty complex.

Dom

[NatanZ]

Hi guys,

I mean, like,
I have VBA codes on Auto_Open and some which depand on cell's value,

But when I change value of a cell that has nothing to do with VBA - I can't undo it.



Any help please?

[Whizbang]

Well, the code to Undo in VBA is:

Please Login or Register  to view this content.

, but you cannot undo several actions, only one. Running this command again would undo the undo (redo).

[NatanZ]

Well, the code to Undo in VBA is:

Please Login or Register  to view this content.

, but you cannot undo several actions, only one. Running this command again would undo the undo (redo).

Says: "Method 'Undo' of object '_application' failed"
Err 1004

[Whizbang]

This probably means there is nothing to Undo. Either no action was done prior to the command, or that action was one of those actions that clears the Undo stack, like something done through VBA.