VSTO Right Click on Sheet menu
Hi
I have tried a few times in the past to build a right click menu in my
VB.net Excel Add-in but have not managed to get a working version going.
Does anyone know of a good artcle on MSDN or the like that walks you through
this. When the user right clicks on a sheet I want the menu to appear
I have tried a few times in the past to build a right click menu in my
VB.net Excel Add-in but have not managed to get a working version going.
Does anyone know of a good artcle on MSDN or the like that walks you through
this. When the user right clicks on a sheet I want the menu to appear
Rory Archibald
Are you trying to create your own, or use the default Cell (or other shortcut) menu? You'd basically need to build a new commandbar then use its ShowPopup method and cancel the right-click event.
ASKER
I am trying to build my own
ASKER
Any chance you have a code example of the method you mentioned? Thanks
Not offhand since I don't use .Net but I'll try and put something together later on.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fantasic! Worked perfectly. Thanks very much for taing the time out to solve a problem that no one else could help me with
Glad to help! :)
One of my goals for this year is to learn more about Office / .Net development so it's nice to get an early start.
Of course that will come right after I become fluent in DAX/MDX for PowerPivot, so I'm not holding my breath. ;)
One of my goals for this year is to learn more about Office / .Net development so it's nice to get an early start.
Of course that will come right after I become fluent in DAX/MDX for PowerPivot, so I'm not holding my breath. ;)