How to UNDO after using a macro

[scottie1]

When I link a macro to a new toolbar then click on the toolbar ti runs the macro but if I want to undo the procedure I cant. There must be a way because Excel has it's own built in UNDO button.

 

[Bowers74]

There is a way, but it can get extremely complex. It all depends on how complex your macro is. You basically have to "back-track" all of the steps your macro has taken and reverse them.



Happy Ho Ho!!! [Cheers]

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[scottie1]

ok I get the message

Merry Xmas

 

[Chattin]

Check out this link for an example

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

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help