Custom Ribbon Tab disappears in Excel 2013?!
I've been creating/using custom ribbon tabs in Excel 2010 for a while now. However I recently opened one of these workbooks in Excel 2013 and the custom tab has gone! When I copy the file back to 2010, the tab is back again!
Does Excel 2013 not support custom tabs?
Or do I need to make a change to the XML to make it compatible with 2013? And if so, then what exactly??
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Yes it does. It uses the same namespace as xl2010.
But it's really hard to say what the problem is without see the ribbonxml you are using.
I've provided a copy of one of the affected projects XML below. It is a mix of the Dynamic Ribbon code by Bob Phillips and some use of your RibbonX Visual Designer Tool (very handy tool I must say. Thank you)Originally Posted by Andy Pope
I;m only using 2006 (It's always worked for me in 2010). Maybe that may have something to do with it?
PHP Code:<!--RibbonX Visual Designer 1.93 for Microsoft Excel 14.0. XML Code produced on 2014/09/19-->
<customUI
xmlns="http://schemas.microsoft.com/office/2006/01/customui"
xmlns:Q="My Shared Ribbon"
onLoad="vbpProjectXYZ.xmlRib_OnLoad.RibbonOnLoad">
<ribbon startFromScratch="false" >
<tabs >
<tab idQ="Q:rxTabUI" >
<group
id="grpDynaRibbon1"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel">
<dynamicMenu
id="mnuDynaRibbon1"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon2"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<button
id="btnDynaRibbon1"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
onAction="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxOnAction"/>
<button
id="btnDynaRibbon2"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
onAction="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxOnAction"/>
<button
id="btnDynaRibbon3"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
onAction="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxOnAction"/>
<separator id="SepStartGov" />
<dynamicMenu
id="mnuDynaRibbon3"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon4"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon5"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon6"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<separator id="SepEndGov" />
<dynamicMenu
id="mnuDynaRibbon7"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon8"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon9"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<dynamicMenu
id="mnuDynaRibbon10"
getContent="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxgetContent"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"/>
<button
id="btnDynaRibbon4"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
onAction="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxOnAction"/>
<button
id="btnDynaRibbon5"
getImage="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImage"
getLabel="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetLabel"
getScreentip="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetScreentip"
getSize="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetImageSize"
getEnabled="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
getVisible="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxGetVisible"
onAction="vbpProjectXYZ.xmlRib_Dynamic_BPver.rxOnAction"/>
<separator id="Separator1" />
<menu
id="Menu1"
label="Ribbon Tests">
<button
id="Button8"
imageMso="RefreshAll"
label="Refresh Ribbon"
onAction="vbpProjectXYZ.xmlRib_OnLoad.TWBRibTestRefresh"/>
<button
id="Button9"
imageMso="HighImportance"
label="Test Loss of State"
onAction="vbpProjectXYZ.xmlRib_OnLoad.TWBRibTestLossOfState"/>
</menu >
<button
id="Button10"
label="Update Check"
onAction="vbpProjectXYZ.xmlRib_OnLoad.TWBRibUpdate"/>
<button
id="Button11"
label="About Me"
onAction="vbpProjectXYZ.xmlRib_OnLoad.TWBRibAbout"/>
</group >
</tab >
</tabs >
</ribbon >
</customUI >
The xml is valid,
does this require a secondary workbook in order to test?
Sorry, not quite sure what you mean about a secondary workbook?
My understanding was that the example used 2 workbooks to build the dynamic ribbon content.
Regardless of that I can not get what you have posted to work in any excel version. So post example that works in 2010 but not in 2013 so we can investigate.
I finally worked out what was causing the problem. I apologise for wasting your time.
It wasn't XML nor Office 2013 that was at fault. It was a error in my VBA code on dynamic visibility.
Full details:
I read the serial number of the computers hard drive using FSO.
I then use a Select Case on that serial number to determine which buttons should be displayed for that users computer.
I have a Case Else to determine default button visibility for any non-specified computer.
However I overlooked making the custom tab visible in Case Else!
Once I added the missing line, the custom tab appears on the PC that has Office 2013 installed.
Last edited by mc84excel; 04-28-2015 at 08:42 PM. Reason: solved
No problem. Glad your sorted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks