Auto Right Click
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
MsgBox "Right-Clicked"
Cancel = True 'cancel default action
End Sub
Tim
"Steven" wrote in message
...
Can you make the Right Click so it automatically runs a macro on the Right
Click instead of having to click the Right Click and then the item. I
just
want one item on the right click and I want it to run automatically.
Thank you,
Steven
|