Prevent Right Click Menu

[Sandy]

How can I prevent a menu popping up when the user Right Clicks - anywhere in
the workbook. Excel 2003.

TIA
Sandy

 

[Andy Pope]

Hi,

Code in the Thisworkbook object to stop right clicking on sheet.

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

Cancel = True

End Sub

Cheers
Andy

 

[Peter T]

In the ThisWorkbook module

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)

Cancel = True

End Sub

Regards,
Peter T

 

[Sandy]

Excellent

Thank you both
Sandy