#SHORTCUTS FOR EXCEL 2010 CODE#
#SHORTCUTS FOR EXCEL 2010 FREE#

#SHORTCUTS FOR EXCEL 2010 FREE#

That’s all! If you have any doubt about the process, please feel free to let me know, I will try my best to make clarification. (It seems the color index 7 is pink, however, that does not related and be the matter) The bottom of the range will be changed to Color pink. Select a few cells and press Ctrl+Shift+B. In the pop up Add-Ins Window, check the box Book1, and then click OK.ġ2. Click Office Button->Excel Options->Add-Ins Tab, choose Excel Add-ins, click Go. To do this, you can choose the file type to be Excel Add-In(*.xlam) in Save As dialog. You will see the Shortcut key is assigned as Ctrl+Shift+B.(We can only assign Ctrl+Shift shortcut key, but not Ctrl+Alt). In the pop up window, we click Button Options….Press B with the hold of Shirt.

#SHORTCUTS FOR EXCEL 2010 CODE#

Again, we click Developer Tab-> Code Group-> Macros Button. Set addin = Application.COMAddIns('ExcelAddin')ĩ. Using the following call back: (We will implement addinUtilities.CallBlueUl later) Add the same Ribbon description to the ribbon.xml file as yoursģ. 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.

Shortcuts for excel 2010