how to add custom ribbon to excel 2010 in vba

Now there IS an 'ActivateTab' command for the ribbon UI but no straightforward means is discussed for getting Excel's ribbon (you'd THINK they would have given you something like Application.Ribbon!)

I can see the Data menu in the 'CommandBars' collection, but it offers no way to activate that menu tab. Alternately, you can also use ' -no luck (for some very strange reason, it triggers a Pivot Table wizard.)

The reason that we send the second Alt key is to clear the ALT key from being active. What this does is send the ALT key (using the %), then the H key, then the ALT key again (the final %). In Excel, to activate the Home Tab using VBA, you'd use: Regardless, it's the only way, so here's how it works: Activating Built in Ribbon Tabs using VBA

This means that it isn't totally reliable, as users can mess up what windows may be active, send other keystrokes, or whatever. it sends keystrokes to the user interface. The bad news is that we have to do it using SendKeys. The good news is that there is a way to select Ribbon tabs using VBA. One of the areas that lacks in the RibbonX API is the ability to programatically activate a specific tab. If you're working with the Office 2007 Ribbon, you may have come to the conclusion that there are areas of, the RibbonX object model which are kind of weak.

How to add custom ribbon to excel 2010 in vba