"Undoable/Redoable" Macro

[3sylvain]

Hello,

I have implement several simple VBA macro which use basic excel command like copy, paste, reformatting, coloring, etc...
My issue is that I would like them to be added to the "do/undo stack", so that when I press Ctrl+Z/Ctrl+Y I can cancel and redo the macro.

I am using Excel 2003


Thanks for your help!

 

[HaHoBe]

Hi, 3sylvain,

no macro action is ever part of that stack - if you are working with events you may undo them. Only solution I know so far: keep a copy of the original sheet or store that in memory/array (but that could be quite a bunch of information).

Last possibility would be not to save the workbook if closed if any action needs to be undone.

Ciao,
Holger

 

[3sylvain]

Hi Hahobe,

ok, I was hoping it would be easily do able, it would have simplified my life.
I know that I can not do it, at least not with some pain that I evaluate to be too much

Again, thanks for your help.

 

[VoG]

It can be done but not easily Excel Developer Tip: Undoing a VBA Subroutine