Can you trap the Delete event?
 

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

Can you trap the Delete event?
 

have a look at

http://www.dailydoseofexcel.com/arch...-deleted-rows/

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

hth

Keith

Can you trap the Delete event?
 

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

Jim Thomlinson


"Dreiding" wrote:

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

Can you trap the Delete event?
 

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.

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Dreiding" wrote:

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

Can you trap the Delete event?
 

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.