Back arrow (Undo) is greyed out after running any script

[Skidood]

Whenever I test a macro, (with what is normally a non-successful result) I cannot Undo the operation by clicking the Undo arrow to go back, I have to close the file and start over with a fresh copy. Hugely annoying...Anyone know why?

 

[My Aswer Is This]

There is no Undo for Macro operations. Not sure why.

 

[Fluff]

Whenever a macro changes something in xl, you loose the undo history. I suspect that this is because xl doesn't know what changes the macro has made.