title: Custom UI Editor For Microsoft Office
body: <p>I want to add one more group in addition to what I have created. But I don't know how to code it. </p>
  
  <p>Well, am a beginner in Custom U.I. Editor For Microsoft Office. (Excel Customized Ribbon Making) </p>
  
  <p>With this code, I have created several menus. But, how can I add more than one group on the same tab. Can anyone help me in this regards.</p>
  
  <pre><code>&lt;customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"&gt;
      &lt;ribbon&gt;
          &lt;tabs&gt;
              &lt;tab
                  id="Tab1"
                  label="QUICK FIX"&gt;
                  &lt;group
                      id="Group1"
                      label="Time Saving Tools"&gt;
                      &lt;menu
                          id="Menu1"
                          image="Home"
                          label="Menu"
                          size="large"&gt;
                          &lt;menu
                              id="Menu2"
                              label="Add New"
                              imageMso="TablePropertiesDialog"&gt;
                              &lt;button
                                  id="Button01"
                                  label="1. Add a new sheet with Current Date"
                                  imageMso="ExportExcel"
                                  onAction="AddSheetCurrentDate" /&gt;
                              &lt;button
                                  id="Button02"
                                  label="2. Add a Calendar Sheet with user given period"
                                  imageMso="CreateTable"
                                  onAction="CalendarMake" /&gt;
                              &lt;button
                                  id="Button03"
                                  label="3. Add a sheet with This Year Calendar"
                                  imageMso="ViewAllProposals"
                                  onAction="ThisYearCalendar" /&gt;
                              &lt;button
                                  id="Button04"
                                  label="4. Create Table of Contents"
                                  imageMso="FunctionsLogicalInsertGallery"
                                  onAction="TableOfContent" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu3"
                              label="Visibility and Protection"
                              imageMso="DatabaseSetLogonSecurity"&gt;
                              &lt;button
                                  id="Button05"
                                  label="1. Make this sheet very hidden"
                                  imageMso="RelationshipsHideTable"
                                  onAction="ActiveSheetVeryHidden" /&gt;
                              &lt;button
                                  id="Button06"
                                  label="2. Show all very hidden sheets"
                                  imageMso="SubformMenu"
                                  onAction="ShowVeryHiddenShts" /&gt;
                              &lt;button
                                  id="Button07"
                                  label="3. Unhide All Sheets"
                                  imageMso="PersonaStatusOnline"
                                  onAction="UnhideAllHiddenShts" /&gt;
                              &lt;button
                                  id="Button08"
                                  label="4. Protect All Sheets"
                                  imageMso="Lock"
                                  onAction="Protect_All_Shts" /&gt;
                              &lt;button
                                  id="Button09"
                                  label="5. Un-Protect All Sheets"
                                  imageMso="FileCompatibilityChecker"
                                  onAction="Unprotect_All_Shts" /&gt;
                              &lt;button
                                  id="Button10"
                                  label="6. List All Un-Protected Sheets"
                                  imageMso="Numbering"
                                  onAction="ListAllUnprotectedShts" /&gt;
                              &lt;button
                                  id="Button11"
                                  label="7. List All Visible and Hidden Sheets"
                                  imageMso="DatasheetColumnLookup"
                                  onAction="List_all_visible_and_hidden_shts" /&gt;
                              &lt;button
                                  id="Button12"
                                  label="8. Lock Cells Containing Formula"
                                  imageMso="FileLinksToFiles"
                                  onAction="LockCellsWithFormula" /&gt;
                              &lt;button
                                  id="Button13"
                                  label="9. Set Custom Zoom % For All Sheets"
                                  imageMso="ZoomPrintPreviewExcel"
                                  onAction="SetCustomZoomForAllShts" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu4"
                              label="Columns and Rows"
                              imageMso="TablePropertiesDialog"&gt;
                              &lt;button
                                  id="Button14"
                                  label="1. Auto Fit All Rows in this Worksheet"
                                  imageMso="GridlinesGallery"
                                  onAction="AutoFitAllRows1" /&gt;
                              &lt;button
                                  id="Button15"
                                  label="2. Auto Fit All Columns in this Worksheet"
                                  imageMso="RelationshipsHideTable"
                                  onAction="AutoFitColumnsInActiveSheet" /&gt;
                              &lt;button
                                  id="Button16"
                                  label="3. Delete All Blank Columns"
                                  imageMso="OmsDelete"
                                  onAction="DeleteBlankColums" /&gt;
                              &lt;button
                                  id="Button17"
                                  label="4. Delete All Blank Rows"
                                  imageMso="OmsDelete"
                                  onAction="DeleteBlankRows" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu5"
                              label="Apply Formula On Cells and Comments"
                              imageMso="ActionInsert"&gt;
                              &lt;button
                                  id="Button18"
                                  label="1. Insert Formula On Selected Cells PS:(No Undo)"
                                  imageMso="AutoSum"
                                  onAction="InsertFormulaOnSelectedCells" /&gt;
                              &lt;button
                                  id="Button19"
                                  label="2. Insert Comments (Multiple Cells) PS:(No Undo)"
                                  imageMso="WebServerDiscussions"
                                  onAction="InsertCommentsOnSelection" /&gt;
                              &lt;button
                                  id="Button20"
                                  label="3. Highlight Cells with Comments PS:(No Undo) "
                                  imageMso="ObjectEffectGlowGallery"
                                  onAction="HighlightCommentOnCells" /&gt;
                              &lt;button
                                  id="Button21"
                                  label="4. Highlight Duplicated Values on the Selected Range PS:(No Undo)"
                                  imageMso="ConditionalFormattingHighlightCompareColumns"
                                  onAction="HighlightDuplicatedValuesOnRange" /&gt;
                              &lt;button
                                  id="Button22"
                                  label="5. Change Comment Box Appearance in this Sheet PS:(No Undo)"
                                  imageMso="AppointmentColorDialog"
                                  onAction="ChangeCommentBoxColorOnThisSheet" /&gt;
                              &lt;button
                                  id="Button23"
                                  label="6. Replace Blank Cells With Zero on the Selected Range PS:(No Undo)"
                                  imageMso="O"
                                  onAction="ReplaceBlankCellsWithZeroOnSelection" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu6"
                              label="Text Utilities"
                              imageMso="FontSchemes"&gt;
                              &lt;button
                                  id="Button24"
                                  label="1. Convert Text To Lower Case PS:(No Undo)"
                                  imageMso="ReplaceDialog"
                                  onAction="ConvertTextToLowerCase" /&gt;
                              &lt;button
                                  id="Button25"
                                  label="2. Convert Text To Upper Case PS:(No Undo)"
                                  imageMso="SlideThemesGallery"
                                  onAction="ConvertTextToUpperCase" /&gt;
                              &lt;button
                                  id="Button26"
                                  label="3. Convert Text To Proper Case PS:(No Undo)"
                                  imageMso="FontSchemes"
                                  onAction="ConvertTextToProperCase" /&gt;
                              &lt;button
                                  id="Button27"
                                  label="4. Remove all Numbers from the Selected Cells PS:(No Undo)"
                                  imageMso="InterconnectDeleteCard"
                                  onAction="RemoveAllNumbersFromSelection" /&gt;
                              &lt;button
                                  id="Button28"
                                  label="5. Remove all Text from the Selected Cells PS:(No Undo)"
                                  imageMso="WatermarkRemove"
                                  onAction="RemoveAllTextFromSelectedRange" /&gt;
                              &lt;button
                                  id="Button29"
                                  label="6. Convert Text Number to Number Format PS:(No Undo)"
                                  imageMso="_1"
                                  onAction="ConvertTextNumbersToNumberFormt" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu8"
                              label="Prefix and Suffix"
                              imageMso="ReviewCompareTwoVersions"&gt;
                              &lt;button
                                  id="Button30"
                                  label="1. Prefix to Existing Data PS:(No Undo)"
                                  imageMso="MailMergeGoToNextRecord"
                                  onAction="PrefixToExistingLeft" /&gt;
                              &lt;button
                                  id="Button31"
                                  label="2. Suffix to Existing Data PS:(No Undo)"
                                  imageMso="MailMergeGoToPreviousRecord"
                                  onAction="SuffixToExistingRight" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu9"
                              label="Clean Up!"
                              imageMso="ControlToolboxOutlook"&gt;
                              &lt;button
                                  id="Button32"
                                  label="1. Remove Leading and Trailing Spaces in this Sheet PS:(No Undo)"
                                  imageMso="AsianLayoutMenu"
                                  onAction="RemoveLeadingTrailingSpacesInActiveSht" /&gt;
                              &lt;button
                                  id="Button33"
                                  label="2. Delete Unused Formats in this Sheet PS:(No Undo)"
                                  imageMso="ControlActiveX"
                                  onAction="DeleteUnusedFormatsActiveSheet" /&gt;
                              &lt;button
                                  id="Button34"
                                  label="3. Delete Unused Formats in this Workbook PS:(No Undo)"
                                  imageMso="CoverPageRemove"
                                  onAction="DeleteUnusedFormatsAllWorkSheets" /&gt;
                              &lt;button
                                  id="Button35"
                                  label="4. Clear Print Area in this Workbook PS:(No Undo)"
                                  imageMso="MasterDocumentUnlinkSubdocument"
                                  onAction="ClearPrintAreaInAllShts" /&gt;
                              &lt;button
                                  id="Button36"
                                  label="5. Clear All Hyperlinks in this Worksheet PS:(No Undo)"
                                  imageMso="HyperlinkRemove"
                                  onAction="RemoveAllHyperlinksThisSheet" /&gt;
                              &lt;button
                                  id="Button37"
                                  label="6. Remove all Styles not in use. PS:(No Undo)"
                                  imageMso="HyperlinkRemove"
                                  onAction="RemoveStylesNotInUse" /&gt;
                              &lt;button
                                  id="Button38"
                                  label="7. Reduce Size of This Workbook. PS:(No Undo)"
                                  imageMso="UpgradeWorkbook"
                                  onAction="ReduceSizeOfWorkbook" /&gt;
                              &lt;button
                                  id="Button39"
                                  label="8. Delete all Blank Sheets. PS:(No Undo)"
                                  imageMso="CoverPageRemove"
                                  onAction="DeleteAllBlankWorkShts" /&gt;
                          &lt;/menu&gt;
                          &lt;menu
                              id="Menu10"
                              label="Sort"
                              imageMso="SortDialog"&gt;
                              &lt;button
                                  id="Button40"
                                  label="1. Sort all Worksheets Alphabetically. PS:(No Undo)"
                                  imageMso="SortUp"
                                  onAction="SortAllWorkSheetsAlphabetically" /&gt;
                              &lt;button
                                  id="Button41"
                                  label="2. Sort all Worksheets by Colour. PS:(No Undo)"
                                  imageMso="ViewBackToColorView"
                                  onAction="SortWorkSheetsByColor" /&gt;
                          &lt;/menu&gt;
                      &lt;/menu&gt;
                  &lt;/group&gt;
              &lt;/tab&gt;
          &lt;/tabs&gt;
      &lt;/ribbon&gt;
  &lt;/customUI&gt;
  </code></pre>