Disable right-click

  • Thread starter Thread starter fredbibi49
  • Start date Start date
F

fredbibi49

Hi,

Does someone know how to disable the right-click with a macro.
I would like to prevent the user using copy, past etc... in m
worksheets.

Thank you!

fre
 
Hi
on a worksheet basis you could use the following code in your worksheet
module:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
cancel=true
End Sub
 
You must log in or register to reply here.

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 Click - Disable item 1
Right Click auto run macro 4
file path or IP address protected 1
Cell Toolbar Dilemma xl2013 13
Disable right click with a difference 2
To disable pressing of Enter key on a sheet 1
Problem disabling double click event 1
Disable user interaction in VBA 1

Back
Top