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
Code:Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) ActiveSheet.Label1.Caption = "Right click=" & Target.Address End Sub







Reply With Quote
Bookmarks