Can you trap the Delete event?

[Dreiding]

If I could trap the delete function (Entire Row), I would be able to control
which Rows the user have delete permissions on.
Does Excel have the capability to trap the Delete event?

Thanks,
- Pat

 

[Keith74]

have a look at

http://www.dailydoseofexcel.com/archives/2006/08/21/capture-deleted-rows/

only other way i can think of might be to use the change event

hth

Keith

 

[Jim Thomlinson]

Are you talking about truely deleting the rows or just clearing the contents
of a row? There is a big difference.

 

[Dreiding]

Yes, I'm concerned with physical row deletion, not cell clearing.
The link Keith74 shows me a way.
However it doesn't cover all the methods of row deletion.
I can still right click on a cell, select Delete..., then EntireRow without
the event being triggered.

I have not figured out how to get the ID for this event.

 

[Keith74]

Have a look at the comment posted by Brad Yundt on the link. That
looks like it does what you want plus it traps the event you describe.