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

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

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

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

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.