View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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