Consulting

Results 1 to 2 of 2

Thread: Solved: Office 2010 Ribbom Customizations

  1. #1
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location

    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
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    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:

    [VBA]
    <mso:cmd app="Excel" dt="1" />
    <mso:customUI xmlns:mso="http://schemas.microsoft.com/office/2009/07/customui">
    <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>
    [/VBA]

    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
  •