Excel ribbon problem with Quick access toolbar

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
 
J

JJ

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
 
R

Ron de Bruin

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
 
J

JJ

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
 
R

Ron de Bruin

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

Jim Rech

I looked at his again as JJ emailed me directly. He thought that getLabel
was the problem attribute but, experiementing, it seems to be getScreentip.
If I remove that from my XML no problem. I searched on getScreentip and
found that we're not the only ones with the issue:

http://www.asap-utilities.com/blog/index.php/2007/10/12/pre-release-asap-utilities-version-421-rc3/

It's funny, if you mouse-over some of my buttons so that you get the screen
tip, only the controls you do not mouse-over product the empty message box.
Once getScreenTip is called by Excel all is well.

--
Jim
| 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
|
|
| > 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
| >>
| >>
| >> > 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
| >> >>
| >> >>
| >> >> > 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
| >> >> >
| >> >>
| >> >>
| >>
| >>
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top