Results 1 to 8 of 8

An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls

    Lately I'm trying to create a custom ribbon tab that can store controls from multiple add-ins.

    I have a number of add-ins I created in the past and - assuming this can be solved - this will be the best way to display multiple add-in controls at once.
    (The other alternatives are to: a) abuse the built-in 'Add-Ins' tab - which quickly gets cluttered with multiple dropdowns & buttons; or b) have a custom ribbon tab for each add-in - which clutters up the ribbon with excess tabs instead).

    This dream has (almost) been solved by the indefatigable Ken Puls. See his article at: http://www.excelguru.ca/blog/2007/03...ong-workbooks/

    I follow the article instructions then make the following changes.

    I open Leech.xlsm with 'Custom UI Editor for Microsoft Office' and change the 'Leech' references to 'Leech1' and save. I then open & save the XLSM as an add-in (leech1.xlam) and load it.
    I then repeat the above but this time I change the 'Leech1' to 'Leech2' in XML and save it as another add-in ('leech2.xlam')

    I check the UI Test tab and at first it appears to be working. But when I click on the buttons, the call backs from the leech groups are both going to leech2 add-in.

    1. I suppose I could customise the callback name for every add-in but that would be a nuisance (and slight risk of doubling up) - isn't there a better way?
    2. It throws me that there is no ribbon object set. What if I want to invalidate a specific group? (I tried adding it to one of them but it didn't work)
    3. As there is no ribbon object - how would I set a loss of ribbon state recovery?
    4. I take it (from a few brief experiments made) that it would be very difficult (if not impossible) to get dynamic menus running for any add-in using the global ribbon frame?
    Last edited by mc84excel; 09-10-2014 at 11:17 PM.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. custom ribbon tooltip help
    By wambaugh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2015, 04:29 PM
  2. [SOLVED] Custom Ribbon
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 08:52 AM
  3. Custom Ribbon Add-in
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2011, 09:46 AM
  4. 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
  5. Excel 2007 : Custom Ribbon
    By LB79 in forum Excel General
    Replies: 23
    Last Post: 10-07-2010, 06:27 AM

Tags for this Thread

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