PC Review


Reply
Thread Tools Rate Thread

Add custom button to existing group Excel 2007

 
 
Viresh Parmar
Guest
Posts: n/a
 
      4th Jan 2010
My employer just recently converted to Excel 2007. I'm trying to
figure out how to customize the ribbon for a few add-ins I use. I'm
using Custom UI Editor to run the XMLs to edit the ribbon.

There is one piece that I'm having trouble with - how to add icons/
buttons to an existing group. For example, I want to add 'Run Report'
button to Editing group. I use the code below, but it doesn't work.
Can someone help me figure out what is wrong with my code? Not even
sure if editing an existing default excel group is possible.

Code:
<ribbon>
<tabs>
<tab idMso="TabHome" >
<group idMso="GroupEditingExcel" >
<button id="RunRpt" label="Run Report" size="normal"
onAction="MacroRpt" imageMso="Calculator" />
</group>
</tab>
</tabs>
</ribbon>
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      4th Jan 2010
See this page Viresh
http://www.rondebruin.nl/xmlribbongroups.htm

--

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


"Viresh Parmar" <(E-Mail Removed)> wrote in message news:d7ec68ae-ff3c-4cb1-b674-(E-Mail Removed)...
> My employer just recently converted to Excel 2007. I'm trying to
> figure out how to customize the ribbon for a few add-ins I use. I'm
> using Custom UI Editor to run the XMLs to edit the ribbon.
>
> There is one piece that I'm having trouble with - how to add icons/
> buttons to an existing group. For example, I want to add 'Run Report'
> button to Editing group. I use the code below, but it doesn't work.
> Can someone help me figure out what is wrong with my code? Not even
> sure if editing an existing default excel group is possible.
>
>
Code:
> <ribbon>
>   <tabs>
>     <tab idMso="TabHome" >
>       <group idMso="GroupEditingExcel" >
>         <button id="RunRpt" label="Run Report" size="normal"
> onAction="MacroRpt" imageMso="Calculator" />
>       </group>
>     </tab>
>   </tabs>
> </ribbon>
>

 
Reply With Quote
 
Viresh Parmar
Guest
Posts: n/a
 
      4th Jan 2010
Thanks Ron! So I guess I have to hide a group and then re-create it
with the desired changes? Doesn't seem that difficult. Thanks!

On Jan 4, 1:57*pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> See this page Vireshhttp://www.rondebruin.nl/xmlribbongroups.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> "Viresh Parmar" <viresh.par...@gmail.com> wrote in messagenews:d7ec68ae-ff3c-4cb1-b674-(E-Mail Removed)...
> > My employer just recently converted to Excel 2007. I'm trying to
> > figure out how to customize the ribbon for a few add-ins I use. I'm
> > using Custom UI Editor to run the XMLs to edit the ribbon.

>
> > There is one piece that I'm having trouble with - how to add icons/
> > buttons to an existing group. For example, I want to add 'Run Report'
> > button to Editing group. I use the code below, but it doesn't work.
> > Can someone help me figure out what is wrong with my code? Not even
> > sure if editing an existing default excel group is possible.

>
> >
Code:
> > <ribbon>
> > * <tabs>
> > * * <tab idMso="TabHome" >
> > * * * <group idMso="GroupEditingExcel" >
> > * * * * <button id="RunRpt" label="Run Report" size="normal"
> > onAction="MacroRpt" imageMso="Calculator" />
> > * * * </group>
> > * * </tab>
> > * </tabs>
> > </ribbon>
> >

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      5th Jan 2010
Correct

The example xml is on my page

--

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


"Viresh Parmar" <(E-Mail Removed)> wrote in message news:00bfd2a7-3e90-45fa-a253-(E-Mail Removed)...
Thanks Ron! So I guess I have to hide a group and then re-create it
with the desired changes? Doesn't seem that difficult. Thanks!

On Jan 4, 1:57 pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> See this page Vireshhttp://www.rondebruin.nl/xmlribbongroups.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> "Viresh Parmar" <viresh.par...@gmail.com> wrote in messagenews:d7ec68ae-ff3c-4cb1-b674-(E-Mail Removed)...
> > My employer just recently converted to Excel 2007. I'm trying to
> > figure out how to customize the ribbon for a few add-ins I use. I'm
> > using Custom UI Editor to run the XMLs to edit the ribbon.

>
> > There is one piece that I'm having trouble with - how to add icons/
> > buttons to an existing group. For example, I want to add 'Run Report'
> > button to Editing group. I use the code below, but it doesn't work.
> > Can someone help me figure out what is wrong with my code? Not even
> > sure if editing an existing default excel group is possible.

>
> >
Code:
> > <ribbon>
> > <tabs>
> > <tab idMso="TabHome" >
> > <group idMso="GroupEditingExcel" >
> > <button id="RunRpt" label="Run Report" size="normal"
> > onAction="MacroRpt" imageMso="Calculator" />
> > </group>
> > </tab>
> > </tabs>
> > </ribbon>
> >


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 "Custom Toolbars Button" stonesfan Microsoft Excel Programming 2 16th Jun 2011 08:01 PM
Re: Excel 2007 "Custom Toolbars Button" Stonesfan Microsoft Excel Programming 0 16th Jun 2011 07:33 PM
Adding a Custom Command Button to the Excel 2007 Ribbon Bishop Microsoft Excel Programming 1 18th May 2009 02:43 PM
2003 - 2007 custom macro and custom button restore. Scott Sornberger Microsoft Excel Misc 11 23rd May 2008 02:41 PM
Can I make a custom button in Excel for the Group feature? =?Utf-8?B?TGlzYQ==?= Microsoft Excel Worksheet Functions 1 20th Dec 2004 09:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:40 PM.