Undo Actions performed by addin

[vini1508]

Hii, i want to know how to create and undo addin which will undo the actions performed by any other addin plss help...

 

[Michael M]

If it's not a Microsoft addin with Undo included, I'm guessing you won't be able to UNDO any code that has been run....when a macro runs the Undo stack is cleared permanantly

 

[vini1508]

thank you

 

[jtakw]

Asked again here: http://www.mrexcel.com/forum/excel-questions/922563-application-undo-not-working-properly.html

 

[Macropod]

See: Undo With Excel VBA

 

[vini1508]

i want to create a undo stack in the above link the example does undo only once..

 

[Michael M]

Can't be done !!!

 

[jtakw]

I'd recommend, write code at the very beginning of your macro to always save a backup copy of your Workbook before running the rest of the macro. This is the only way.

 

[vini1508]

There is a boost excel addin by Boost for Excel | Excel Shortcuts and Time-Saving Tools - WSP Analytics | Boost for Excel they provide the feature of undo.. so it s not like it can't be done there must be some way to do it... please help me

 

[MARK858]

There is not a way to undo an action by a macro. As it has already been stated in most cases running VBA removes the undo stack.
What the Boost addin is probably doing is doing a test of what state the sheet was in before and storing it in it's memory (for instance testing and storing in memory what color a cell is, then making the cell yellow then when you do Ctrl + Z calling the originally stored information).
Basically doing a back up of the previous settings similar to what jtakw has already suggested.

It is not using the Undo stack.

See the link below

http://www.jkp-ads.com/articles/undowithvba00.asp