Run code before "delete row" using Workbook_SheetBeforeRightClick

[cgcamal]

Hi to all,

I'm trying to execute a Macro (Macro1) if I do Right Click over a cell and I select
from the contextual menu the option "Delete-->Entire Row".

Below in Pseudo code what I'm trying (In red what I don't know how to say to Excel in VBA code):

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

SelectRow = Target.row

If [COLOR=Red]"Delete Entire Row option" Is selected[/COLOR] Then
   [COLOR=Green] 'Before delete entire row[/COLOR]
     Run Macro1
   [COLOR=Green] 'After Run Macro1 continue the execution of delete entire row[/COLOR]
End If
    
End Sub

How can I do this?

PS: I have a "Workbook_SheetChange" in the same ThisWorkbook module, only if matters for this new event I want to monitor.

Many thanks in advance for any help.

Regards.

 

[cgcamal]

**bump**

 

[xenou]

I'm not sure. Is there anything in this article to help:
http://www.dailydoseofexcel.com/archives/2006/08/21/capture-deleted-rows/

I've seen this question enough times to think that a BeforeRowsDelete Event would be a great addition to the Excel events collection.

 

[cgcamal]

Hi xenou,

Thanks for your reply.

I'll try to follow steps in that link.

Best regards

 

[Gary McMaster]

Hi Cesar,

I was trying to do something similar a while ago and ran into the following thread:

http://www.mrexcel.com/forum/showthread.php?t=80626

Hope there's something you can use.

Gary