MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Jacob, another question

Posted by Jim on December 11, 2001 4:26 PM

Hi Jacob,
Thanks for the help. 1 more hurdle, i need to disabe the
right click of the mouse or the end user will still be
able to insert rows and likewise tear-up the formlas.
If you have any ideas please resond.
Thanks, Jim

Posted by Jacob on December 11, 2001 5:40 PM

This is an easy one. By the way if the sheet is protected rows cannot be inserted. But if you want to disable the right click try this.

Private Sub Worksheet_BeforeRightClick
End Sub

thats all there is too it. You could add more code to trigger if they try a right click like a message box etc, but this will cancel the right click.

Let me know if you need any more help