+ Reply to Thread
Results 1 to 8 of 8

Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

  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

    Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    I've been enthusiastically embracing the concept of a global custom ribbon tab to replace the use of the built-in Add-Ins tab (See http://www.excelforum.com/excel-prog...-ken-puls.html )

    Would it be possible to have a workbook that, while it 'plugs into' the global custom ribbon tab (ie it has controls that appear on this tab), it also has controls that appear on a custom tab unique to that workbook?

    The idea being that:

    If you have the UI Host.xlam installed, the workbook has custom controls appearing on the global custom tab AND has custom controls on its own (workbook-level) custom tab.
    If the UI Host.xlam is not installed, the workbook will have only have controls appearing on its own tab.

    I'm new to XML and am having difficulty working this out. xmlns is linked to Q="My Shared Ribbon". Could there be an extra xmlns (whatever that is) that is NOT linked to "My Shared Ribbon"?
    *******************************************************

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

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

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    You should have the normal namespace before the custom one so you should be able to simply add controls and tabs as you would in any other workbook. Did you try it?
    Remember what the dormouse said
    Feed your head

  3. #3
    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

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    What's a 'namespace'? (The XML I have written to date has been 99% copy/paste...)

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    The xmlns part.

  5. #5
    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

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    When validating using Custom UI Editor, it gives an error message "Not a valid XML document! There are multiple root elements. Line 20, position 2."
    Attached Files Attached Files

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    That wasn't what I suggested! What I suggested was like this:
    HTML Code: 

  7. #7
    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

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    Quote Originally Posted by romperstomper View Post
    That wasn't what I suggested!
    I thought it was! (You said to have the normal namespace before the custom one and that a namespace is the xlmns part)

    Quote Originally Posted by romperstomper View Post
    What I suggested was like this:
    It works! Thanks Rory +1


    Now I need to work out how to clone the Shared controls onto the custom tab. But that's getting off-topic for this thread so I'll mark as solved.

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Workbook to have its own Custom Ribbon Tab well as use the Global Shared Tab?

    Quote Originally Posted by mc84excel View Post
    I thought it was! (You said to have the normal namespace before the custom one and that a namespace is the xlmns part)
    Exactly:
    HTML Code: 
    Not duplicate the whole customui part!

+ 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. [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
  2. Replies: 9
    Last Post: 07-16-2014, 03:32 AM
  3. [SOLVED] Activate custom Ribbon Tab on Workbook Open
    By jewelsharma in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-20-2014, 09:10 PM
  4. How to create new workbook with custom ribbon in VBA
    By MichalJB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2013, 02:52 PM
  5. Slow opening for workbook with custom ribbon.
    By ericsastud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2011, 11:09 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