Excel Hints

Results 1 to 2 of 2

Thread: Solved: Office 2010 Ribbom Customizations

  1. #1

    Solved: Office 2010 Ribbom Customizations

    In 2010 you can customize the ribbon without XML or the CustomUI editor.

    The customizations seems to persist across Excel, etc. sessions.

    Does anyone know where the customizations are stored?

    Paul

  2. #2
    No idea how the post got doubled up. Time stamps are the same

    In 2010 you can export and import the customizations to/from an XML file that (sample)looks like this:

    VB:
    <mso:cmd app="Excel" dt="1" /> 
    <mso:customUI xmlns:mso="[URL="http://schemas.microsoft.com/office/2009/07/customui"]http://schemas.microsoft.com/office/2009/07/customui[/URL]"> 
    <mso:ribbon><mso:qat/> 
    <mso:tabs> 
    <mso:tab id="mso_c1.CCBC110" label="Design"> 
    <mso:group idQ="mso:GroupSmartArtCreateGraphic"/> 
    <mso:group idQ="mso:GroupSmartArtLayouts"/> 
    <mso:group idQ="mso:GroupSmartArtQuickStyles"/> 
    <mso:group idQ="mso:GroupSmartArtReset"/> 
    </mso:tab> 
    <mso:tab id="mso_c2.CCBCD6F" label="Format"> 
    <mso:group idQ="mso:GroupSmartArtShapes"/> 
    <mso:group idQ="mso:GroupShapeStyles"/> 
    <mso:group idQ="mso:GroupWordArtStyles"/> 
    <mso:group idQ="mso:GroupArrange"/> 
    <mso:group idQ="mso:GroupSmartArtSize"/> 
    </mso:tab> 
    </mso:tabs> 
    </mso:ribbon> 
    </mso:customUI> 
    
    
    Formatting tags added by mark007
    but it's not where Excel, etc. seems to store its customizations

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •