Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before right click in a sheet
Please help if you can think of a solution for this.
I have code in a sheet module that calls a function to open a custom menu "before right click". The program works as intended, but when the user right clicks if nothing is selected and the user just clicks in the sheet again (cancels the menu), the standard shortcut menu will sometimes appear and stay "lit" and other times it flashes on and off. Is there a way to keep the built-in menu from appearing in this case? Note that in other sheets, I want the built-in menu to be fully functional. Some code to dismiss the menu would be best. Your example code would be most beneficial. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before right click in a sheet
In the beforeRight click there is a cancel argument. Set it to True in
your code. cancel = True -- Regards, Tom Ogilvy raj wrote in message ... Please help if you can think of a solution for this. I have code in a sheet module that calls a function to open a custom menu "before right click". The program works as intended, but when the user right clicks if nothing is selected and the user just clicks in the sheet again (cancels the menu), the standard shortcut menu will sometimes appear and stay "lit" and other times it flashes on and off. Is there a way to keep the built-in menu from appearing in this case? Note that in other sheets, I want the built-in menu to be fully functional. Some code to dismiss the menu would be best. Your example code would be most beneficial. Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before right click in a sheet
You have done it again, Tom my old friend. Thank you.
-----Original Message----- In the beforeRight click there is a cancel argument. Set it to True in your code. cancel = True -- Regards, Tom Ogilvy raj wrote in message ... Please help if you can think of a solution for this. I have code in a sheet module that calls a function to open a custom menu "before right click". The program works as intended, but when the user right clicks if nothing is selected and the user just clicks in the sheet again (cancels the menu), the standard shortcut menu will sometimes appear and stay "lit" and other times it flashes on and off. Is there a way to keep the built-in menu from appearing in this case? Note that in other sheets, I want the built- in menu to be fully functional. Some code to dismiss the menu would be best. Your example code would be most beneficial. Thanks in advance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't right click in an Excel 2007 sheet | Excel Discussion (Misc queries) | |||
First Click or Keystroke jumps you to the first sheet | Excel Discussion (Misc queries) | |||
Not able to use Right-Click in excel sheet | Excel Discussion (Misc queries) | |||
Keyboard Shortcut for right-click on sheet tab | Excel Worksheet Functions | |||
shortcut for right click on sheet bar | Excel Discussion (Misc queries) |