Consulting

Results 1 to 5 of 5

Thread: Create Sub Groups with Ribbon

  1. #1
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location

    Create Sub Groups with Ribbon

    I am wondering how do I create a sub group within the ribbon. Basically, I want a Main group call REPORT, then when I click on it, a list of reports is listed then I can click on one of the reports then execute that report, my Ribbon is running out of room and I like tidy it up. Just to make it interesting, how about a group within a group (I don't need it now, but I may in the future). I would like this to be created with Excel.

    Thanks

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    For a project's ribbon, I created a main Group with 6 buttons.

    Each button would toggle the Visibility of another Group

    When loading the ribbon, the 6 'sub-groups' we not visible initially

    That way, I could have none, or only one, or different combinations of the 'sub-groups'

    I can put together an example if you want
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Paul:
    Can you post an example of this Ribbon Project? Thanks.

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    This was done pretty quickly, but shows what I was suggesting

    It adds a new tab 'Example' with a main group that's always visible and which has 6 toggle buttons, each which shows or hides another 'sub-group'

    When I did it in my project, I actually had the data in arrays, but doing it this brute force way is clearer
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Thanks again, Paul. I will take a peek as to how it is done.

Posting Permissions

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