Need some help on keeping UNDO/REDO working after running macro's. Almost there ;-)

Hi,
So far I did't find a solution that can keep undo/redo after running macro's. Except those for undoing the last macro, but you can't keep track of multiple undo's!!!

So I already made a macro to make a new copy of the complete workbook which should be run after every change using Sub Workbook_SheetChange.
Then add a Application.OnUndo to go back 1 workbook, where you add again a OnUndo to go back over and over up to the maximum workbooks you can and want to keep in memory.

Using Sub Workbook_BeforeSave I need to make a copy from the VBA-code in the copied workbook before saving it and close all the copies.
I wonder if one could copy the vba-code from one workbook-module to an other workbook?

Anyone?

Formula:

Please Login or Register  to view this content.