Results 1 to 5 of 5

Thread: How To Create Medium Size Button In Excel Office Ribbon Tab

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0

    Question How To Create Medium Size Button In Excel Office Ribbon Tab

    I want to create two buttons like 'wrap text' and 'Merge' at home tab. Mean only two buttons well align. But I am getting only two option normal or large. If I am using normal, its creating space for three buttons nd if I use Large, its create only single button. Pls sugest, how I can do it

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    To give a better idea of what you are getting now, attach a snapshot. But before that, try something like this

    PHP Code:
    <customUI onLoad="AlphaRibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2009/07/customui">
        <
    ribbon>
            <
    tabs>
                <
    tab idMso="TabFormulas">
                    <
    group id="myGroupID" label="MyGroupLabel">
                        <
    button
                            id 
    "myButtonOneID"
                             
    label "MyButtonOneLabel"
                             
    size "normal"
                            
    onAction "MyButtonOneAction"
                            
    imageMso "ReviewShowAllComments"
                            
    screentip "Tip: MyButtonOne Tip"
                            
    supertip="MyButtonOne Supertip" />
                        <
    button
                            id 
    "myButtonTwoID"
                            
    label "MyButtonTwoLabel"
                            
    size "normal"
                            
    onAction "MyButtonTwoAction"
                            
    screentip "Tip: MyButtonTwo Tip"
                            
    supertip "ExcelFox has all your ribbonX solutions"
                            
    imageMso="SheetProtect" />
                    </
    group>
                </
    tab>
            </
    tabs>
        </
    ribbon>
    </
    customUI
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Replace
    PHP Code:
    xmlns="http://schemas.microsoft.com/office/2009/07/customui 
    used for Excel 2010 (and 2013) with
    PHP Code:
    xmlns="http://schemas.microsoft.com/office/2006/01/customui 
    for Excel 2007
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  4. #4
    Junior Member
    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0
    Thanks for reply, but in the example, we have space to create third button. However, I want to create only two buttons which will look like in alignment group of home tbtab in excel

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Ah, so you wanted to ensure that there are no unwanted spaces after the two buttons. The vertical alignment of two rows of button across the three existing row spaces of the ribbon group is not doable at least in the current xml schemas for Office 2007 and 2010. The MS CustomUI development team might come up with something in the future (not sure).
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Test copy Activate Ribbon Tab In Excel 2007 2010 *
    By Excel Fox in forum Test Area
    Replies: 16
    Last Post: 01-22-2019, 05:05 PM
  2. Replies: 2
    Last Post: 04-17-2013, 11:53 PM
  3. How To Use getKeytip to Assign the Key Tip of a Ribbon Tab
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 0
    Last Post: 04-19-2011, 11:25 PM
  4. How To Add A New Button In A Ribbon Group
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 0
    Last Post: 04-09-2011, 01:13 PM
  5. How To Add A New Ribbon Tab In Excel
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 0
    Last Post: 04-09-2011, 12:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •