Excel Undo Event After Running A Macro

[animas]

I see that running any macro cancels all of the Undo events of Excel.
I am not talking about Undo the Macro. I am talking about Undo non-macro tasks that I did immediately before running the macro.

Is there any workaround to this?

 

[Michael M]

Basically, NO
Once a macro has been run the undo stack is emptied and it can't be redone.

 

[Dryver14]

No you cannot do that, however if the same thing is affected each time and you would like that to be reversed then you could include that bit in the macro, for instance a formula in a cell etc, if the macro is changing a lot of things you dont want it to then it is not the macro for you.

 

[animas]

Thanks.