How to support Undo

[Jiri Pik]

Is there any easy way how to support Undo of any write operation I do on an excel sheet?

 

For example, the result of my function is a range. I convert it to a range formula, in doing so, I overwrite some cells and the user would like to undo this function.

 

 

[Govert van Drimmelen]

Hi Jiri,

The only customizable Undo support that Excel has, is to set a macro to run as the (one) current Undo step. For this you call Application.OnUndo(...)

But you have to keep track of whatever information you need to undo the work, and it doesn't support a stack of Undo operations, the user will be left with only a single level of Undo.

More details here: http://msdn.microsoft.com/en-us/library/office/ff194135.aspx

-Govert