I add a Ribbon support Item to my project. I create an Excel Add In named ExcelAddIn using VSTO SE and Excel 2007Ģ. And if you want to understand this post better, you can refer an article on Andrew Whitechapel’s blog first, here: ġ. And if you have any difficulty about that, please feel free to let me know). I think you can convert it to VB version without much effort. I will show the process step by step (I am writing C# example. My thought is that, we should still use VBA to assign the shortcut key, but alternatively we should expose an ExcelAddin Automation Service to let VBA call our function. If we create the button via customize ribbon.xml, we cannot get the button’s handle in VBA.

And then save the module as a Excel Add In. And we can assign a shortcut key for the VBA Module. So we can create a VBA Module get the CommandControl’s handle and call it Execute() method. The thread I posted above is target at the scenario that we create the button using CommandBar and CommandBarControl. Sorry about not realizing you are working on Office 2007 and using Ribbon.xml to customize your Office UI.

Microsoft excel shortcut keys download