View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dreiding Dreiding is offline
external usenet poster
 
Posts: 80
Default 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