View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tywardreath Tywardreath is offline
external usenet poster
 
Posts: 5
Default Disable Right Click in Spreadsheet

Hi

I've found the following code to disable right clicking with a spreadsheet,
however within Excel 2003 it doesn't work.

Private Sub Worksheet_BeforeRightClick(ByVal Target _
As Excel.Range, Cancel As Boolean)
Cancel = True 'prevents normal RClick menu from appearing
End Sub

Does anyone know how to stop right clicking?

Cheers, Ty