|
|
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
.
|