Prevent Right Click Menu
 

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

TIA
Sandy

Prevent Right Click Menu
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sandy" wrote in message
...
How can I prevent a menu popping up when the user Right Clicks - anywhere
in the workbook. Excel 2003.

TIA
Sandy

Prevent Right Click Menu
 

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" wrote in message
...
How can I prevent a menu popping up when the user Right Clicks - anywhere
in
the workbook. Excel 2003.

TIA
Sandy

Prevent Right Click Menu
 

Excellent

Thank you both
Sandy

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

TIA
Sandy