Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I 'catch' a 'delete cells' event
I am using Office 2000 and am using the worksheet_chage event to manipulate
a few things in the sheet. The 'Change' event doesn't catch when a user deletes a range of cells. Is it possible to catch the deletion of a range of cells, or a row or a column? Thanks in advance!! |
#2
|
|||
|
|||
You can set up a keypress trap in the open event of the workbook:
Application.Onkey "{del}","RunMyDeleteProcedure" at that procedure you can still clear the cells or whatever, and know that they pressed that key. Be sure to turn off the running of your procedure when the workbook is closed (or deactivated, maybe): Application.Onkey "{del}" Bob Umlas Excel MVP "Eric" wrote: I am using Office 2000 and am using the worksheet_chage event to manipulate a few things in the sheet. The 'Change' event doesn't catch when a user deletes a range of cells. Is it possible to catch the deletion of a range of cells, or a row or a column? Thanks in advance!! |
#3
|
|||
|
|||
Eric,
IIRC, Excel XP handles this properly, and XL2000 and earlier versions don't. What version do you have, and what is the code that you are running? HTH, Bernie MS Excel MVP "Eric" wrote in message ... I am using Office 2000 and am using the worksheet_chage event to manipulate a few things in the sheet. The 'Change' event doesn't catch when a user deletes a range of cells. Is it possible to catch the deletion of a range of cells, or a row or a column? Thanks in advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete shaded cells | Excel Discussion (Misc queries) | |||
In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |