ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I set-up a macro to undo a previously run macro? (https://www.excelbanter.com/excel-discussion-misc-queries/46967-can-i-set-up-macro-undo-previously-run-macro.html)

bruatrocket

Can I set-up a macro to undo a previously run macro?
 
is there an easy way set to up a macro to reverse the changes made by a
previousy run marco?

Alan

No, not generically I don't believe. It can only be done as far as I know by
reversing each step of the original macro in another macro.
Once a macro is run the 'Undo' greys out in the same way as if you save the
file as code is executed and the 'Undo' is gone.
I would be interested to hear any thoughts on this from other people on this
as to the possibility of this,
Regards,
Alan.
"bruatrocket" wrote in message
...
is there an easy way set to up a macro to reverse the changes made by a
previousy run marco?




Bernie Deitrick

Visit John Walkenbach's excellent site:

http://j-walk.com/ss/excel/tips/tip23.htm

HTH,
Bernie
MS Excel MVP


"bruatrocket" wrote in message
...
is there an easy way set to up a macro to reverse the changes made by a
previousy run marco?





All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com