Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to click on 1 cell and have it hyperlinked to a highlighted c | Excel Worksheet Functions | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
edit the buttons in right click menu | Excel Worksheet Functions |