UNDO MACRO in Excel

  • Thread starter Thread starter Madan Sitaraman
  • Start date Start date
Madan said:
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
Click to expand...
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
 
Back
Top