Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
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/i...rsion-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 "Ron de Bruin" wrote in message ... | 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 | | | | | | |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ribbon problem with Quick access toolbar
Thanks for the info Jim
I check it out this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Rech" wrote in message ... 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/i...rsion-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 "Ron de Bruin" wrote in message ... | 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 | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I hide the Quick Access Toolbar in Excel 2007? | Excel Discussion (Misc queries) | |||
unable to customize quick access toolbar in excel 07 | New Users to Excel | |||
How do I export the Quick Access Toolbar from Excel? | Excel Discussion (Misc queries) | |||
Is there a way to port your quick access toolbar in excel | Setting up and Configuration of Excel | |||
Excel 2007 Quick Access Toolbar Changes not Saved | Excel Discussion (Misc queries) |