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

Hi JJ

I think you are talking about the same bug we have when we use Jim's add-in from my site

http://www.rondebruin.nl/ribbon.htm
See point 4

Do you see the same problem as in your workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
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

Hello,

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

I think you are talking about the same bug we have when we use Jim's add-in from my site

http://www.rondebruin.nl/ribbon.htm
See point 4

Do you see the same problem as in your workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
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

Hi JJ

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

No, I report this bug and I hope it will be fixed in a update.
But I think it will be the next Excel version



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
Hello,

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

I think you are talking about the same bug we have when we use Jim's add-in from my site

http://www.rondebruin.nl/ribbon.htm
See point 4

Do you see the same problem as in your workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
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

Ron,

Thank you for the information.

Do you know, if a case id exists for this problem at Microsoft like

CASE_ID_NUM: SRX080129600328?

Does a work-around exist for this issue?

For example is it possible to force Excel 2007 at load of the user defined
ribbon to load all the texts that correspond to the getLabels?

Could be the use of the Invalidate method at load a solution to force the
update of the strings before a user can select €œAll commands€� in the €œQuick
Access Toolbar€� Menu?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

No, I report this bug and I hope it will be fixed in a update.
But I think it will be the next Excel version



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
Hello,

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

I think you are talking about the same bug we have when we use Jim's add-in from my site

http://www.rondebruin.nl/ribbon.htm
See point 4

Do you see the same problem as in your workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
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

Hi JJ

I report it to the Dev team directly
No workaround at that moment and Jim and I try also a few things with no luck.

Could be the use of the Invalidate method at load a solution to force the
update of the strings before a user can select €œAll commands€� in the €œQuick
Access Toolbar€� Menu?

I see if I have time to play with it soon
I am sure that Jim will read this thread also so maybe he also will look again.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
Ron,

Thank you for the information.

Do you know, if a case id exists for this problem at Microsoft like

CASE_ID_NUM: SRX080129600328?

Does a work-around exist for this issue?

For example is it possible to force Excel 2007 at load of the user defined
ribbon to load all the texts that correspond to the getLabels?

Could be the use of the Invalidate method at load a solution to force the
update of the strings before a user can select €œAll commands€� in the €œQuick
Access Toolbar€� Menu?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

No, I report this bug and I hope it will be fixed in a update.
But I think it will be the next Excel version



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
Hello,

The problem in my example is the same than in Jim's example. Is there a way
to solve the problem and having work the "All commands" option correctly?

Regards

Jürgen



"Ron de Bruin" wrote:

Hi JJ

I think you are talking about the same bug we have when we use Jim's add-in from my site

http://www.rondebruin.nl/ribbon.htm
See point 4

Do you see the same problem as in your workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
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