How do I 'catch' a 'delete cells' event

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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!!
 
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,

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How do I delete images in a specific range 1
Limiting deletion of cells 6
I can only delete an entire row not a cell in excel 2013? 1
Code to format cells on several worksheets 2
Need help deleting data 2
Protect cells but allow for user input. 3
ComboBox for a range of cells 2
Worksheet Change Event - copy cell to another sheet 2

Back
Top