how to switch off of rightclick?

[bhandari]

is it posssible to do not work right click on sheet?

 

[Joe4]

You can do it with VBA code.

Go to the sheet you want to apply it to, right-click on the sheet tab name, select "View Code", and paste this code in the resulting VB Editor window:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
End Sub

 

[mumps]

Place this macro in the worksheet code module:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
End Sub

Oops. Looks like Joe4 got there first.

 

[bhandari]

Thank you

 

[mumps]

My pleasure.

 

[bhandari]

Can You please help me with this thread

https://www.mrexcel.com/forum/excel-questions/1036925-need-help-text-boxes.html