Ignore right mouse click on form control

[MalcolmGill]

Hi gurus in the sky

I use form control buttons to make life easy for my users. I want to disable a right click totally. I have discovered how to disable the "cut, copy, paste etc" menu by pasting into ThisWorkbook

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

But having achieved that, a right click on the form control button still shows a "Move here, copy here, cancel" menu.

I want to suppress the use of the right click button across the whole workbook including form buttons. Any thoughts oh wise ones?

 

[Yongle]

Protecting a worksheet would do the trick
- there are various boxes to tick
- tick everything EXCEPT Edit Objects

The above may cause other issues that require a workaround, but does suppress shape right-click context menu
- sheet protection prevents user editing an object

 

[MalcolmGill]

Many thanks Yongle. I'll give it a go.
As ever, instant response from you guys!