{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":117,"n_cols":4,"rows_kept":117}
[]
["Hide or Display Built-in Ribbon Tabs with a macro"]
[]
["See also the other examples on the getVisible page on my site"]
[]
["The RibbonX in this file use startFromScratch to true to hide the Ribbon and QAT ."]
["Note: if you also want to hide your OfficeButton or File(Backstage) menu see the dictator examples on this page"]
["http://www.rondebruin.nl/win/s3/win003.htm"]
["It will Create a custom tab for every original tab on the Ribbon with the same name."]
["It will Add every original group to this custom tabs to duplicate the original tabs."]
["We can now use getVisible to hide/display the tabs with a VBA macro."]
[]
["Note: Normal getVisible is not working for specific built-in tabs/groups/controls when you use startFromScratch = true."]
["             Because they are Custom tabs now we can use getVisible to hide/display the tabs with a VBA macro."]
[]
["Use the Custom UI Editor to see or edit the RibbonX if you want (I also Paste the RibbonX on this sheet)."]
[]
["By default the Custom Tabs are not visible, but you can change this if you want by using"]
["MyTag = \"show\" in the Workbook_Open event in the ThisWorkbook module."]
["See the commented code in the ThisWorkbook module if you want the Tab visible by default."]
[]
["We use a callback named getVisible to be able to use a VBA macro to Hide or display the tab you want."]
["Look at the code in the module \"RibbonModule\" in the VBA editor (Alt F11)"]
["You see that I add getVisible=\"GetVisible\" in every line that add a custom Tab to the Ribbon in the RibbonX"]
["You also see tag=\"ribhome\" in this xml line, we use this Tag in the code to tell which tab we want to hide or show."]
[]
[" <tab id=\"MyCustomHomeTab\" label=\"Home\" insertAfterMso=\"TabHome\" getVisible=\"GetVisible\" tag=\"ribhome\" >"]
[]
["Use the buttons below to run the macro's to display all tabs or only the Custom Home or Review Tab."]
["See the comments in the VBA code for the names of the other tabs."]
[]
["Home tab","Review tab","All tabs","All tabs"]
[]
[]
[]
[]
[]
["RibbonX from this Workbook :"]
[]
["<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>"]
["<customUI onLoad=\"RibbonOnLoad\" xmlns=\"http://schemas.microsoft.com/office/2006/01/customui\">"]
[]
["  <!-- Set startFromScratch to true to hide the Ribbon and QAT--> "]
["  <ribbon startFromScratch=\"true\">"]
[]
["<!-- Create a custom tab for every original tab on the Ribbon with the same name.       -->"]
["<!-- Add every origenal group to this custom tabs to duplicate the original tabs.       -->"]
["<!-- We can now use getVisible to hide/display the tabs with a VBA macro.               -->"]
["<!-- Note: Normal getVisible is not working for specific built-in tabs/groups/controls.  -->"]
[]
["    <tabs>"]
["      <tab id=\"MyCustomHomeTab\" label=\"Home\" insertAfterMso=\"TabHome\" getVisible=\"GetVisible\" tag=\"ribhome\">\n"]
[null,"<group idMso=\"GroupClipboard\" />"]
[null,"<group idMso=\"GroupFont\" />"]
[null,"<group idMso=\"GroupAlignmentExcel\" />"]
[null,"<group idMso=\"GroupNumber\" />"]
[null,"<group idMso=\"GroupStyles\" />"]
[null,"<group idMso=\"GroupCells\" />"]
[null,"<group idMso=\"GroupEditingExcel\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomInsertTab\" label=\"Insert\" insertAfterMso=\"TabInsert\" getVisible=\"GetVisible\" tag=\"ribinsert\" >"]
[null,"<group idMso=\"GroupInsertTablesExcel\" />"]
[null,"<group idMso=\"GroupInsertIllustrations\" />"]
[null,"<group idMso=\"GroupInsertChartsExcel\" />"]
[null,"<group idMso=\"GroupInsertLinks\" />"]
[null,"<group idMso=\"GroupInsertText\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomPageLayoutTab\" label=\"Page Layout\" insertAfterMso=\"TabPageLayoutExcel\" getVisible=\"GetVisible\" tag=\"ribpagelayout\">"]
[null,"<group idMso=\"GroupThemesExcel\" />"]
[null,"<group idMso=\"GroupPageSetup\" />"]
[null,"<group idMso=\"GroupPageLayoutScaleToFit\" />"]
[null,"<group idMso=\"GroupPageLayoutSheetOptions\" />"]
[null,"<group idMso=\"GroupArrange\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomFormulasTab\" label=\"Formulas\" insertAfterMso=\"TabFormulas\" getVisible=\"GetVisible\" tag=\"ribformulas\">"]
[null,"<group idMso=\"GroupFunctionLibrary\" />"]
[null,"<group idMso=\"GroupNamedCells\" />"]
[null,"<group idMso=\"GroupFormulaAuditing\" />"]
[null,"<group idMso=\"GroupCalculation\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomDataTab\" label=\"Data\" insertAfterMso=\"TabData\" getVisible=\"GetVisible\" tag=\"ribdata\">"]
[null,"<group idMso=\"GroupGetExternalData\" />"]
[null,"<group idMso=\"GroupConnections\" />"]
[null,"<group idMso=\"GroupSortFilter\" />"]
[null,"<group idMso=\"GroupDataTools\" />"]
[null,"<group idMso=\"GroupOutline\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomReviewTab\" label=\"Review\" insertAfterMso=\"TabReview\" getVisible=\"GetVisible\" tag=\"ribreview\">"]
[null,"<group idMso=\"GroupProofing\" />"]
[null,"<group idMso=\"GroupComments\" />"]
[null,"<group idMso=\"GroupChangesExcel\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomViewTab\" label=\"View\" insertAfterMso=\"TabView\" getVisible=\"GetVisible\" tag=\"ribview\">"]
[null,"<group idMso=\"GroupWorkbookViews\" />"]
[null,"<group idMso=\"GroupViewShowHide\" />"]
[null,"<group idMso=\"GroupZoom\" />"]
[null,"<group idMso=\"GroupWindow\" />"]
[null,"<group idMso=\"GroupMacros\" />"]
["       </tab>"]
[]
["      <tab id=\"MyCustomDeveloperTab\" label=\"Developer\" insertAfterMso=\"TabDeveloper\" getVisible=\"GetVisible\" tag=\"ribdeveloper\">"]
[null,"<group idMso=\"GroupCode\" />"]
[null,"<group idMso=\"GroupControls\" />"]
[null,"<group idMso=\"GroupXml\" />"]
[null,"<group idMso=\"GroupModify\" />"]
["       </tab>"]
[]
["    </tabs>"]
[]
["  </ribbon>"]
["</customUI>"]