right click

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

how can I ban right clicks on my pages - I dont really
want people to click wrongly on buttons. also how would I
stop the code for me to work on it though!!

Amy
 
Thanks thats great but it doesnt stop the right clicking
on buttons!

Is there a way round that?

amy
-----Original Message-----
You can use a event for this

Copy this in the Thisworkbook module

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

See Chip Pearson's site also
http://www.cpearson.com/excel/events.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"amy" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top