| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Right Click Menu
How can I prevent a menu popping up when the user Right Clicks - anywhere in
the workbook. Excel 2003. TIA Sandy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Right Click Menu
Hi,
Code in the Thisworkbook object to stop right clicking on sheet. Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Sandy" wrote in message ... How can I prevent a menu popping up when the user Right Clicks - anywhere in the workbook. Excel 2003. TIA Sandy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Right Click Menu
In the ThisWorkbook module
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _ ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub Regards, Peter T "Sandy" wrote in message ... How can I prevent a menu popping up when the user Right Clicks - anywhere in the workbook. Excel 2003. TIA Sandy |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Right Click Menu
Excellent
Thank you both Sandy "Sandy" wrote in message ... How can I prevent a menu popping up when the user Right Clicks - anywhere in the workbook. Excel 2003. TIA Sandy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button in the context menu (right click menu) | Excel Programming | |||
| Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
| Add menu item to right-click menu | Excel Programming | |||
| Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
| Adding menu to the mouse right click pop-up menu | Excel Programming | |||
Linear Mode
