right click

[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

 

[Ron de Bruin]

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

 

[Guest]

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

message news:[email protected]...

 

[Ron de Bruin]

Protect you sheet