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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

right mouse click - cut copy paste in userform textboxes? 4
Disable sheets tabs right mouse button! 3
Mouse using "Right click to paste" 8
Launching macros from the right mouse button 1
Trouble with modifying cell right-mouse-click context menu 2
Right mouse paste 2
right mouse click and IF...Then 5
InputBox Cancel Button 1

Back
Top