How to capture Windows Menu Key in Excel (the right-click menu called via key press)  
Author Message
Frank Muehlenkamp





PostPosted: Visual Basic for Applications (VBA), How to capture Windows Menu Key in Excel (the right-click menu called via key press) Top

Hello,

I am trying to find a way to capture the event of a user pressing the Windows Menu Key in an Excel Worksheet.

I have the right-click event captured on the worksheet, no problem. In that case, I display my own menu, rather than the "Cell" menu. But the user can still press the menu key and the default "Cell" menu will appear.

I do not want to modify the cell menu, since I would like to work with both, my custom menu and the cell menu. I just want to control the display of the cell menu.

Application.Onkey does not seem to offer a keycode for this key (e.g. such as {MENU}).

Any ideas

Many thanks...




Microsoft ISV Community Center Forums1