ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to undo the delete action? (https://www.excelbanter.com/excel-discussion-misc-queries/183941-how-undo-delete-action.html)

abs

How to undo the delete action?
 
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

How to undo the delete action?
 
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?

ABS wrote:

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

Mike H

How to undo the delete action?
 
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

"ABS" wrote:

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.



All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com