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
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
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