Undo macros
 

I have macros that I wish to be able to undo. I know that I can set the
..OnUndo property of the Application object, but how do I create a macro that
knows how to undo the actions of another? Where do I store the data? Do I
make a physical copy of all the ranges affected in another, hidden,
workbook? or... ?

Any help would be appreciated

Undo macros
 

The answer would be application specific. when your macro "does", it should
make provision for "undoing".

See John Walkenbach's page on this topic:

http://j-walk.com/ss/excel/tips/tip23.htm

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
I have macros that I wish to be able to undo. I know that I can set the
.OnUndo property of the Application object, but how do I create a macro
that
knows how to undo the actions of another? Where do I store the data? Do
I
make a physical copy of all the ranges affected in another, hidden,
workbook? or... ?

Any help would be appreciated