Youtube.com/VbaA2z (subscribe for new videos every weekend!): RibbonX - Build First-Class UI Directly into App Ribbon

Subscribe Now!
New videos every Weekend!

Like what I do? Donate

Did I help you? Did one of my tutorials save you sometime?

You can say thank you by buying me a cup of coffee, I go through a lot of it.

Help keep Greater Good resources free for everyone. Please donate today.

This page is not monitored so for questions please comment on the youtube video page. For suggestions email vbaa2z.team@gmail.com

Download project or source code from below link(s)

Click here for all videos

Resources

* OfficeCustomUIEditorSetup Download
* 2.1 Parts
* 2.2 Elements
* 3.2 imageMso Table
* imageMSO Browser/Preview

Goto VSTO RibbonX - ALL

RibbonX - 01

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabHome">
<group id="Group5" label="Loader">
<button id="Button5" label="Upload to Database" size="normal" onAction="code1" imageMso="FilePublishAsWebPage"/>
<button id="Button6" label="Run Reports" size="normal" onAction="code2" imageMso="Chart3DBarChart"/>
<button id="Button7" label="Misc" size="normal" onAction="code3" imageMso="MacroConditions"/>
<button id="Button8" label="Info" size="normal" onAction="code4" imageMso="Info"/>
<button id="Button9" label="Help" size="normal" onAction="code5" imageMso="Help"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

RibbonX - 02

------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<backstage>
<tab id="customTab" label="Custom">
<firstColumn>
   <taskGroup id="customTaskGroup" label="Custom Task Group">
      <category id="tgCategory1" label="Category One">
         <task id="task1" label="Task 1" imageMso="FileOpen"/>
         <task id="task2" label="Task 2" imageMso="FileSave"/>
         <task id="task3" label="Task 3" imageMso="FileSaveAs"/>
      </category>
   </taskGroup>
</firstColumn>
</tab>
</backstage>
</customUI>

------------------------------------------

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
<tabs>
<tab id="customTab" label="Custom Tab">
   <group id="customGroup" label="Custom Group">
      <button id="customButton" label="Custom Button" imageMso="HappyFace" size="large" onAction="Callback" />
   </group>
</tab>
</tabs>
</ribbon>
</customUI>

------------------------------------------
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab id="customTab" label="Contoso" insertAfterMso="TabHome">
   <group idMso="GroupClipboard" />
   <group idMso="GroupFont" />
   <group id="customGroup" label="Contoso Tools">
      <button id="customButton1" label="ConBold" size="large" onAction="conBoldSub" imageMso="Bold" />
      <button id="customButton2" label="ConItalic" size="large" onAction="conItalicSub" imageMso="Italic" />
      <button id="customButton3" label="ConUnderline" size="large" onAction="conUnderlineSub" imageMso="Underline" />
   </group>
   <group idMso="GroupEnterDataAlignment" />
   <group idMso="GroupEnterDataNumber" />
   <group idMso="GroupQuickFormatting" />
</tab>
</tabs>
</ribbon>
</customUI>
------------------------------------------


<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<commands>
<command idMso="Bold" enabled="false"/>
<command idMso="Save" onAction="MySave"/>
</commands>
</customUI>
------------------------------------------

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab idMso="TabInsert">
   <group id="customGroup" label="Contoso" insertAfterMso="GroupIllustrations">
      <button id="customButton" label="Document ID" size="large" imageMso="ListNumVal" onAction="insertDocID" />
   </group>
</tab>
</tabs>
</ribbon>
</customUI>
------------------------------------------

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab id="customTab" label="Contoso" insertAfterMso="TabHome">
<group idMso="GroupClipboard" />
<group idMso="GroupFont" />
<group id="customGroup" label="Contoso Tools">
   <button id="customButton1" label="ConBold" size="large" onAction="conBoldSub" imageMso="Bold" />
   <button id="customButton2" label="ConItalic" size="large" onAction="conItalicSub" imageMso="Italic" />
   <button id="customButton3" label="ConUnderline" size="large" onAction="conUnderlineSub" imageMso="Underline" />

<gallery id="gallery" label="Gallery" itemWidth="88" itemHeight="68"
size="large" imageMso="HappyFace" >
   <item id="item1" imageMso="FreezePanes" />
   <item id="item2" imageMso="FreezePanes" />
   <item id="item3" imageMso="FreezePanes" />
   <item id="item4" imageMso="FreezePanes" />
</gallery>


</group>
<group idMso="GroupEnterDataAlignment" />
<group idMso="GroupEnterDataNumber" />
<group idMso="GroupQuickFormatting" />
</tab>
</tabs>
</ribbon>
</customUI>

RibbonX - 03

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">

<qat>
<documentControls>
<control idMso="CalculateNow" />
<control idMso="HyperlinkInsert" />
<button id="Button5" label="Upload to Database" onAction="code1" imageMso="Grouping"/>

</documentControls>

</qat>

</ribbon>

<backstage>

   <button idMso="FileSave" visible="false"/>
   <button idMso="FileSaveAs" visible="false"/>
   <button idMso="FileOpen" visible="false"/>
   <button idMso="FileClose" visible="false"/>
   <button idMso="ApplicationOptionsDialog" visible="false"/>
   <button idMso="FileExit" visible="false"/>
   <tab idMso="TabInfo" visible="false"/>
   <tab idMso="TabRecent" visible="false"/>
   <tab idMso="TabNew" visible="false"/>
   <tab idMso="TabPrint" visible="false"/>
   <tab idMso="TabShare" visible="false"/>
   <tab idMso="TabHelp" visible="false"/>
   <tab idMso="TabPublish" visible="false"/>
   <tab idMso="TabSave" visible="false"/>
   <tab idMso="TabOfficeStart" visible="false"/>

      <tab id="customTab" label="Custom">
      <firstColumn>
      <taskGroup id="customTaskGroup" label="Custom Task Group">
      <category id="tgCategory1" label="Category One">
      <task id="task1" label="Task 1" imageMso="FileOpen"/>
      <task id="task2" label="Task 2" imageMso="FileSave"/>
      <task id="task3" label="Task 3" imageMso="FileSaveAs"/>
      </category>
      </taskGroup>
      </firstColumn>
      </tab>
</backstage>

</customUI>

RibbonX - 04

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
<contextualTabs>
<tabSet idMso="TabSetChartTools">
   <tab id="Tab1" label="Chart Utilities">
   <group id="Group1" label="Chart Utilites">
      <button id="Button5" label="Upload to Database" size="normal" onAction="code1" imageMso="FilePublishAsWebPage"/>
      <button id="Button6" label="Run Reports" size="normal" onAction="code2" imageMso="Chart3DBarChart"/>
      <button id="Button7" label="Misc" size="normal" onAction="code3" imageMso="MacroConditions"/>
      <button id="Button8" label="Info" size="normal" onAction="code4" imageMso="Info"/>
      <button id="Button9" label="Help" size="normal" onAction="code5" imageMso="Help"/>
   
   </group>
   </tab>
</tabSet>


<tabSet idMso="TabSetPivotTableTools">
      <tab id="Tab1x" label="Pivot Utilities">
      <group id="Group1x" label="Pivot Utilites">
      <button id="Button5x" label="Upload to Database" size="normal" onAction="code1" imageMso="FilePublishAsWebPage"/>
      <button id="Button6x" label="Run Reports" size="normal" onAction="code2" imageMso="Chart3DBarChart"/>
      <button id="Button7x" label="Misc" size="normal" onAction="code3" imageMso="MacroConditions"/>
      <button id="Button8x" label="Info" size="normal" onAction="code4" imageMso="Info"/>
      <button id="Button9x" label="Help" size="normal" onAction="code5" imageMso="Help"/>
      
      </group>
      </tab>
</tabSet>



</contextualTabs>
</ribbon>
</customUI>

RibbonX - 05

https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/3caf6b18-34cb-4352-bd31-77a26980c00e

https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/700e4451-8706-40c5-8d7b-896e4ae21b69

RibbonX - 06

https://docs.microsoft.com/en-us/office/vba/api/office.iribbonui

https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/21312cb8-be0f-412c-8184-acd533a1410b

https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/846e8fb6-07d3-460b-816b-bcfae841c95b

Contextual Tabs

Also known as Tool Tabs, these are additional tabs that will appear when you are working with specific objects.

SmartArt Tools
SmartArt Tools
Chart Tools
Chart Tools
Drawing Tools
Picture Tools
Pivot Table Tools
Pivot Table Tools
Header & Footer Tools
Table Tools
Pivot Chart Tools
Pivot Chart Tools
Pivot Chart Tools
Ink Tools
Sparkline Tools
Timeline Tools
Slicer Tools
Search Tools
Query Tools
Equation Tools

VSTO - Customize / Design Excel Ribbon using XML & .NET Tutorial Link: https://www.youtube.com/watch?v=C-F_hLt-goA XML code for reference below:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="Ribbon_Load">
<ribbon>

<contextualTabs>
<tabSet idMso="TabSetChartTools">
<tab id="Tab1" label="Chart Utilities">
<group id="Group1" label="Chart Utilites">
<button id="Button5X" label="Change Chart Type" size="normal" onAction="CheckBoxtest" imageMso="FilePublishAsWebPage"/>
<button id="Button6X" label="Change Color Def" size="normal" onAction="CheckBoxtest" imageMso="Chart3DBarChart"/>
</group>

</tab>
</tabSet>

</contextualTabs>

<tabs>

<tab id="Tab2" label="VSTO-XML">
<group id="Group1x" label="Version Info">
<labelControl id="Label1" getLabel="getLabelInfo"/>
<labelControl id="Label2" getLabel="getLabelInfo"/>
<labelControl id="Label3" getLabel="getLabelInfo"/>
</group>

<group id="Group2" label="More Controls">
<button id="Button1" onAction="ShowTP" label="Show Task Pane" showImage="false"/>
<button id="Button2" onAction="ShowUF" label="Show Win Form" showImage="false"/>
</group>

<group id="Group3" label="Dropdown">
<dynamicMenu id="dynamic" label="Dynamic Menu" getContent="GetMenuContent"/>
<dropDown id="dropDown" onAction="Location" label="City">
<item id="London" label="London"/>
<item id="NewYork" label="New York"/>
<item id="Delhi" label="Delhi"/>
<button id="Budapest" label="Budapest" onAction="Budapest_bt"/>
</dropDown>
<labelControl id="Label4" label="Label4"/>

</group>

<group id="Group4" label="InputBox">
<editBox id="EditBox1" onChange="EditBox_TextChanged" getText="EditBoxGetText" label="Number 1" showImage="false"/>
<editBox id="EditBox2" onChange="EditBox_TextChanged" getText="EditBoxGetText" label="Number 2" showImage="false"/>
<editBox id="EditBox3" getText="EditBoxGetText" label="Total " showImage="false"/>
<button id="Button4" onAction="CaclTotal" label="Cacl Total" showImage="false"/>
</group>

<group id="Group5" label="Checkbox">
<checkBox id="CheckBox1" onAction="CheckBoxClck" getPressed="CheckBoxPressed" label="CheckBox1"/>
<button id="Button5" onAction="CheckBoxtest" label="Check Box Test" showImage="false"/>
<toggleButton id="ToggleButton1" label="ToggleButton1" showImage="false"/>
</group>

</tab>
</tabs>
</ribbon>
</customUI>

Youtube.com/VbaA2z (subscribe for new videos every weekend!)

Search

RibbonX - Build First-Class UI Directly into App Ribbon