I'm trying to work out how to select the "Add-ins" tab on the standard Excel ribbon using VBA.
I've created a custom toolbar and in Excel 2007, 2010 or 2013, the custom toolbar is displayed under the add-ins tab.
I want to highlight this tab using VBA to make sure the user knows that the toolbar is there. Already I display a dialogue box message to tell them about it but I find that most people don't read the dialogue box.
Someone suggesting I use Sendkeys but that sounds like an unreliable method. There must be a better way.