right click
 

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

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" wrote in message ...
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" wrote in
message ...
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


.

Protect you sheet


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



wrote in message ...
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" wrote in
message ...
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


.