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
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" <[email protected]> wrote in message news:[email protected]...
> 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
message news:[email protected]...
>> 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
<[email protected]> wrote in message news:[email protected]...
> 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]...
>>> 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
>>
>>
>>.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks