S Sandy Jun 13, 2008 #1 How can I prevent a menu popping up when the user Right Clicks - anywhere in the workbook. Excel 2003. TIA Sandy
How can I prevent a menu popping up when the user Right Clicks - anywhere in the workbook. Excel 2003. TIA Sandy
A Andy Pope Jun 13, 2008 #2 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
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
P Peter T Jun 13, 2008 #3 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
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
