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