Excel ribbon problem with Quick access toolbar
Hello,
I am having errors in the €śMore Commands€¦€ť menu of the €śCustomize Quick
access Toolbar€ť in Excel 2007 when I use a user defined ribbon.
I define the ribbon using an xml declaration and vba code as described in
the Office 2007 tutorial on this subject.
When I use the getLabel=€ťxxx€ť command to charge my menu items according to
the language selection, the €śAll Commands€ť selection in the €śMore Commands€¦€ť
menu of the €śCustomize Quick access Toolbar€ť will generate an empty error
message for every getLabel command used in the XML ribbon definition.
This only happens, if I did not yet load the load the getLabels by changing
the ribbon tab and activating by clicking with the mouse on it.
It seems that the Customize Quick access Toolbar does not execute the
getLabel commands.
Is there a way to force the execution of all of the getLabels right after
loading the user ribbon?
Is this a known Excel 2007 bug?
Is there another work around?
Here an example from the xml ribbons definition:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon startFromScratch="false"
<tabs
<tab id="CustomTab" label="XLSTAT"
<group id="Group17" getLabel="GroupLabel" getVisible="ModuleVisible"
<menu id="BUT17" image="dose" size="large"
getScreentip="GroupLabel"
<button id="BUT1701" image="icoDOS" getLabel="ItemLabel"
onAction="RunProcDOS"/
<button id="BUT1702" image="icoPLF" getLabel="ItemLabel"
onAction="RunProcPLF"/
</menu
</group
</tab
</tabs
</ribbon
</customUI
Regards
Jurgen
|