View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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