Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
MsgBox "Double-Clicked"
End Sub
OR
Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
MsgBox "Right-Clicked"
End Sub
beg pardon, 1 year later , am looking for the left click version for events. this would be for a mouse left click only, so can tab into cell without the event taking place. thanks.
Bookmarks