Undo function to undo Visual Basic commands

Hi guys,
is there a function that can undo Visual Basic commands??
After executing a macro is there a function that can undo the workbook (Other than saving the workbook before the execution of the macro)

Thanks for your help

Running VBA any code clears the Undo stack therefore preventing anything being 'undone'. You can use Application.Undo immediately in a worksheet change event if someone has entered a value you don't want them to for example but that's about it.

I've seen code that builds up a history of changes that then allows a custom undo routine to be used but never really tried it myself and don't think it's ever that perfect.

I thought I'd read somewhere that things might have changed in Excel 2010 (don't quote me on that though as not seen it yet).

Dom

They have made some changes to undo/redo in 2010 but doesn't look like that includes anything to do with code: http://blogs.msdn.com/b/excel/archiv...05/477660.aspx

Not surprised really.

Dom

No - you have to write another macro that undoes everything you just did and then assign it using Application.OnUndo. See this J-Walk tip for example.