How to undo the delete action?

[ABS]

After finally getting some add-ins into my Excel (Office2003) surprisingly
some of the default settings have changed. One of the most annoying changes
is that I cannot undo the delete action after pressing the delete button on
the keyboard. Does anyone know how to fix this problem? Before the add-ins I
had absolutely no trouble with that.

 

[Dave Peterson]

I have no idea what your addin does, but one of the byproducts of most macros is
that the undo/redo stack is cleared.

Does your addin contain any events that would fire after you clear the cells?

In fact, does your addin steal the delete key and run its own code?

 

[Mike H]

Hi,

Macros clear the undo stack so if your running one when the sheet changes
then you have to keep track of things yourself.

Have a look here

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

Mike