Trapping Copy To Range Before Copy/Cut Paste

[Rasm]

Thanks - I will try that - Right now I use the selectionchange in the workbook - so looks like I can use the code there as well - I check it out

[Rasm]

ahhh - as it turns out - I can trap the paste part like this - so your code Kris - I can use to trap the copy part.

So now I can trap both events - hehehee - I do it all in ThisWorkbook - but that makes no real diff

Anyway - Now that I know how to trap both mouse actions - I can move forward

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
    ActiveSheet.Label1.Caption = "Right click=" & Target.Address
End Sub