I am looking for a way to add a custom tab in the Excel ribbon which would carry a few buttons. I chanced on some resources addressing it via Google but all look dodgy and outrageously complicated. 

What is a quick and simple way to do that ? I&#39;d like the new tab to get loaded when my VBA gets loaded into Excel..

**UPDATE** : 
I tried this example from [here][1] but get an &quot;object required&quot; error on the last instruction :

    Public Sub AddHighlightRibbon()
    Dim ribbonXml As String
    
    ribbonXml = &quot;&lt;mso:customUI xmlns:mso=&quot;&quot;http://schemas.microsoft.com/office/2009/07/customui&quot;&quot;&gt;&quot;
    ribbonXml = ribbonXml + &quot;  &lt;mso:ribbon&gt;&quot;
    ribbonXml = ribbonXml + &quot;    &lt;mso:qat/&gt;&quot;
    ribbonXml = ribbonXml + &quot;    &lt;mso:tabs&gt;&quot;
    ribbonXml = ribbonXml + &quot;      &lt;mso:tab id=&quot;&quot;highlightTab&quot;&quot; label=&quot;&quot;Highlight&quot;&quot; insertBeforeQ=&quot;&quot;mso:TabFormat&quot;&quot;&gt;&quot;
    ribbonXml = ribbonXml + &quot;        &lt;mso:group id=&quot;&quot;testGroup&quot;&quot; label=&quot;&quot;Test&quot;&quot; autoScale=&quot;&quot;true&quot;&quot;&gt;&quot;
    ribbonXml = ribbonXml + &quot;          &lt;mso:button id=&quot;&quot;highlightManualTasks&quot;&quot; label=&quot;&quot;Toggle Manual Task Color&quot;&quot; &quot;
    ribbonXml = ribbonXml + &quot;imageMso=&quot;&quot;DiagramTargetInsertClassic&quot;&quot; onAction=&quot;&quot;ToggleManualTasksColor&quot;&quot;/&gt;&quot;
    ribbonXml = ribbonXml + &quot;        &lt;/mso:group&gt;&quot;
    ribbonXml = ribbonXml + &quot;      &lt;/mso:tab&gt;&quot;
    ribbonXml = ribbonXml + &quot;    &lt;/mso:tabs&gt;&quot;
    ribbonXml = ribbonXml + &quot;  &lt;/mso:ribbon&gt;&quot;
    ribbonXml = ribbonXml + &quot;&lt;/mso:customUI&gt;&quot;
    
    ActiveProject.SetCustomUI (ribbonXml)
    End Sub


  [1]: http://msdn.microsoft.com/en-us/library/ee767705.aspx

All Ribbonx Solutions on Gang of Coders

Total of 1 Ribbonx Solutions

How to add a custom Ribbon tab using VBA?