UNDO MACRO in Excel

[Madan Sitaraman]

Does anybody know how to UNDO a macro in Excel-2002?? I checked the
microsoft link - http://support.microsoft.com/?kbid=211922 but couldn't
find which one enables the undoing of macros.

Any help would be greatly appreciated!

Thanks
Madan

 

[Matthew Connor]

Does anybody know how to UNDO a macro in Excel-2002?? I checked the
microsoft link - http://support.microsoft.com/?kbid=211922 but couldn't
find which one enables the undoing of macros.

Any help would be greatly appreciated!

Thanks
Madan

I asked the same question a little while ago. In short, you can't do
it easily.

A couple of work-arounds that were suggested:
1. programmatically copy pre-macro values to a hidden worksheet and
write a second macro that would copy them back.

2. use the 'Shared Workbook' features of Excel to track changes. Undo
would be supported by discarding these changes.

From the Google Group Archives:
http://tinyurl.com/isss

(long link:
http://groups.google.com/groups?hl=...5xyqQeODHA.2212%40TK2MSFTNGP12.phx.gbl&rnum=1)


Hope this helps,

Matthew