Consulting

Results 1 to 7 of 7

Thread: Make custom tab visible across all workbook

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

    Make custom tab visible across all workbook

    Wonder if people have XML accompany with vba to have custom tab visible across all workbooks? If I create an xlam, this the tab is visible across all workbooks, however, I only wanted xlsm. I try to create one, however, if I switched workbooks, my tab disappears and if I switched back, it comes back. I would like the tab to be visible all the time, thanks.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    I don't believe you can. If you have a custom tab in an xlsm, it is only visible when that workbook is active. I think that this is a fundamental principle of contextual tabs.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Thanks for your insight, xld. That would explained no matter what I tried, the tab keeps on disappearing on me.....

  4. #4
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    You can use namespace to have customUI shared across workbooks.

    See Namespace example about 2/3rds of the way done the page.
    http://www.andypope.info/vba/ribboneditor.htm
    Cheers
    Andy

  5. #5
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    But that still isn't all workbooks Andy, it is only for those selected workbooks.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  6. #6
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    If I open the namespacea.xlsm a new tab My Utils tab is displayed. If I then use CTRL+N to create a new workbook the tab is still displayed. Same if I open and existing file it still available.
    Cheers
    Andy

  7. #7
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Thanks Andy. I will denfinitely take a look at NameSpace.

Posting Permissions

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