Disable secondary mouse button

I do not want the user to be able to change anything in the workbook - they must only insert information
I have used the OnKey command to disable esc,tab,F1,F2 etc and am also using DisplayFullScreen and so on
I now have to disable the secondary mouse button

Perhaps there is an easier way of doing all this disabling as it is pretty long the way I'm going

I am using the code below in one of my spreadsheets. It disables right clicking and displays a message.
Paste it in 'ThisWorkbook' module.

Please Login or Register  to view this content.

Regards.

Hi
Thanks for the code but I am new to VBA and the code makes no sense to me the way it is written

The code runs and the msgbox appears but the mouse secondary button(right) still works
Any ideas what im doing wrong?

Hi Hadj,
Did you paste it in 'ThisWorkbook'? See attached image.
Right_Click.jpg

Regards

Hi
Thanks a lot - works just the way I want
Regards

Hi
Thanks a lot - works just the way I want
Regards