+ Reply to Thread
Results 1 to 2 of 2

Put VBA ribbon together with Custom UI Editor Ribbon

  1. #1
    Registered User
    Join Date
    12-06-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    2

    Lightbulb Put VBA ribbon together with Custom UI Editor Ribbon

    Hi guys!!

    I have one question regarding the ribbons. On first I was using VBA to generate a custom ribbon that would look like this:

    1.jpg

    I have coded it in a way that it will change tab by tab, each tab have diff options and the menu will have diff options when the user activate the tab.

    Then I wanted to put another custom ribbon with large icons, which seems to be possible only via the Custom UI Editor for Office, so I did:

    2.jpg

    What I want is to have this two menus together. You see, there is Add-Ins for the VBA made custom bar and Navigation Bar for the Custom UI one.
    I want to be able to use the "Navigation Bar" that is made via Custom UI to add my VBA menus.

    Is that possible?

    Thanks a lot!!
    Last edited by czarlando; 01-22-2016 at 08:25 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Put VBA ribbon together with Custom UI Editor Ribbon

    You would need to add a dynamic menu to the customUI. Then you can populate that via VBA.

    http://www.excelguru.ca/blog/2007/01...nu-an-example/
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Assistance with Custom Tab and Groups on Excel Office Ribbon using Custom UI Editor.
    By sdavison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 06:13 AM
  2. [SOLVED] Ribbon Change based on Non-Ribbon Object
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-07-2014, 01:18 PM
  3. [SOLVED] An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2014, 10:01 PM
  4. [SOLVED] Custom Ribbon
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 08:52 AM
  5. Custom Ribbon Add-in
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2011, 09:46 AM
  6. Ribbon - Multiple xlam adding into single Ribbon tab
    By gooopil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 03:40 PM
  7. Excel 2007 : Custom Ribbon
    By LB79 in forum Excel General
    Replies: 23
    Last Post: 10-07-2010, 06:27 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1