disable right mouse button menu

[tbablue]

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
ActiveWorkbook.Worksheets("UTILISATION").Calculate
End Sub

Is there a simple way to disable the menu that appears as a result of clicking the RIGHT mouse button? As per the code above - I wanna use the right button to update my sheet; the workbook is set for manual calculation.

Cheers

Ken

 

[kpark91]

After the calculation.

How about putting

Cancel = True

?

 

[schielrn]

F9 will recalculate your workbook and shift+F9 will recalculate just a sheet.

There is plenty of code out there to delete items off of your right click menu if you want to go that route, but it will delete it for all workbooks and not just this one unless you add all those menu options back.

It may be a bigger task than you really want, but there is plenty of code to be searched on this board to do it if you really wanted to. You can also cancel your event at the end of it too.