VBA Express Forum  




Go Back   VBA Express Forum > VBA Code & Other Help > Office 2007 Ribbon UI
     Feedback     
Register FAQ Members Arcade Knowledge Base Training Articles Consulting

Reply
 
Thread Tools Display Modes
Old 10-12-2010, 05:31 PM   #1
Paul_Hossler

 
Joined: Apr 2007
Posts: 2,084
Kb Entries: 0
Articles: 0
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

Local Time: 06:54 AM
Local Date: 05-24-2013
Location:

 
Reply With Quote Top
Old 10-16-2010, 05:09 AM   #2
Paul_Hossler

 
Joined: Apr 2007
Posts: 2,084
Kb Entries: 0
Articles: 0
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 tags courtesy of www.thecodenet.com

but it's not where Excel, etc. seems to store its customizations

Paul

Local Time: 06:54 AM
Local Date: 05-24-2013
Location:

 
Reply With Quote Top
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 03:54 AM.


Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright © 2004 - 2012 VBA Express