how to cancel the right mouse button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm tryng to accomplish something with the beforerightclick method, I
want when the user press the right mouse button, the menu that normaly
appears (Cut Copy Paste .....),doesn't appears so the user isn't abble to
cut, copy, paste or change the format of the cells
TIA
 
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
End Sub


--
Jim
| Hi, I'm tryng to accomplish something with the beforerightclick method, I
| want when the user press the right mouse button, the menu that normaly
| appears (Cut Copy Paste .....),doesn't appears so the user isn't abble to
| cut, copy, paste or change the format of the cells
| TIA
 
Back
Top