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
|