Add Ins and Undo

[Todd Bardoni]

I created an Add In that adds two options to my Cell menu. The first simply changes a selection of formulas to values and the other Trims and Cleans a selection. However, when I use it I don't get the option to undo. Is there a solution for this?

 

[Richie(UK)]

Hi t,

Generally speaking if you do something via a macro then the Undo feature is reset, ie there's no going back!

Your only real option, as far as I am aware, is to make some sort of back-up of the data before you act on it and then use this info for restoration purposes.

Here's JWalk's thoughts on it:

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


HTH

 

[Todd Bardoni]

Thanks for the link Richie. Since the add in is just for my use I'll deal without the Undo...too much effort for little benefit (until I need it ). But, that info will come in handy later.