LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JJ JJ is offline
external usenet poster
 
Posts: 122
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I hide the Quick Access Toolbar in Excel 2007? D7 Excel Discussion (Misc queries) 2 November 17th 09 02:27 AM
unable to customize quick access toolbar in excel 07 klofosho New Users to Excel 1 September 4th 09 08:00 PM
How do I export the Quick Access Toolbar from Excel? MikeF[_2_] Excel Discussion (Misc queries) 1 February 17th 09 11:15 PM
Is there a way to port your quick access toolbar in excel Kevin Setting up and Configuration of Excel 2 May 28th 08 07:36 PM
Excel 2007 Quick Access Toolbar Changes not Saved den4673 Excel Discussion (Misc queries) 1 April 17th 07 02:21 PM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"