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