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.