Results 1 to 7 of 7

Thread: List of MSO Identifiers for inbuilt tabs

  1. #1
    Neophyte Alison Campbell's Avatar
    Join Date
    Oct 2018
    Location
    Adelaide, South Australia
    Posts
    4
    Articles
    0
    Excel Version
    365

    List of MSO Identifiers for inbuilt tabs



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there a list of the names for each inbuilt ribbon tab that can be used with insertBeforeMso and insertAfterMso in the Custom UI Editor? I have searched high and low with no success. Many can be worked out by guessing, but I don't seem to be able to identify the Help tab.

    Apologies if this answer is already here somewhere, but I have spent a lot of time looking on this site and elsewhere with no success!

    Cheers

    Alison C



  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    208
    Articles
    0
    Excel Version
    2007
    .
    Try 30010
    Attached Files Attached Files

  3. #3
    Neophyte Alison Campbell's Avatar
    Join Date
    Oct 2018
    Location
    Adelaide, South Australia
    Posts
    4
    Articles
    0
    Excel Version
    365
    Thanks for your response, Conjurer.

    I should probably have been more specific in my initial post, in that I'm using Excel 365 under Windows 10, so am using the Office 2010 Custom UI (although I'm not sure if that makes a difference - but the structure of your list looks more like the items on the old menu bar rather than the ribbon).

    I'm not sure how to use a code such as 30010 in place of a word in the Tab line of the UI Editor. I'm currently using <tab id="StellarTab" label="Stellar" insertAfterMso="TabDeveloper"> but would prefer something that translates to <insertBeforeMso="TabHelp"> in order to insert the tab specifically before Help rather than after Developer. This is because the Stellar tab is in an .xlam loaded from the XLStart folder, but I also have a couple of other files that load their own tabs, which I would like to position between the Stellar tab and Help. Sadly, "TabHelp" achieves nothing.

    The problem is that the Stellar tab loads first, then the tab for the next file I open is positioned after the Developer tab but before the Stellar tab. My only other option is to place it right at the end of the toolbar, but I'd really prefer Help to be at the end in all instances. I've tried playing with the idQ option to specify the Stellar tab, but with even less success as there seems to be an even bigger gap in the available information!

    I realise words such as TabDeveloper are probably constants representing numbers, but don't know how to tell the UI editor that I'm substituting "TabDeveloper" with the value 30010 for Help. If I enclose the number within inverted commas it doesn't work, which is what I would expect. But if I omit the inverted commas, the label "insertAfterMSO" turns from red to blue, and the custom ribbon tab isn't recognised at all. Both options fail the Validator.

    So the simplest solution would be if I could find a reference that tells me what the correct word is for the Help tab, as TabDeveloper is for the Developer tab. Failing that, how to substitute a value in place of a constant.

    Cheers

    Alison C

  4. #4
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    41
    Articles
    0
    Excel Version
    2016
    Office 2010 Help Files: Office Fluent User Interface Control Identifiers
    https://www.microsoft.com/en-us/down...s.aspx?id=6627
    Cheers
    Andy

    www.andypope.info

  5. #5
    Neophyte Alison Campbell's Avatar
    Join Date
    Oct 2018
    Location
    Adelaide, South Australia
    Posts
    4
    Articles
    0
    Excel Version
    365
    Thank you, Andy. This looks like a useful resoure for a number of different circumstances, so I appreciate you pointing me towards it!

    What it does confirm is that I was correct at the start in assuming TabHelp was the name of the Help tab. Unfortunately, insertBeforeMso="TabHelp" seems to be completely ignored by the Custom UI Editor... :-(

    Cheers

    Alison C

  6. #6
    Neophyte Alison Campbell's Avatar
    Join Date
    Oct 2018
    Location
    Adelaide, South Australia
    Posts
    4
    Articles
    0
    Excel Version
    365
    The only difference I can see between the tabs that are not ignored by insertBeforeMso or insertAfterMso and TabHelp is that the former are listed as Tab Set = None (Core Tab) whereas TabHelp is listed as Tab Set = None (Backstage View). Which seems to be a misattribution, given that Help is always visible, not just in Backstage View...

  7. #7
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    41
    Articles
    0
    Excel Version
    2016
    Try this ribbonx. Note the subtle name change for the help tab.

    PHP Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
        <
    ribbon startFromScratch="false">
            <
    tabs>
                <
    tab id="customTab1" label="Before Help" insertBeforeMso="HelpTab"/>
                <
    tab id="customTab2" label="Default"/>
                <
    tab id="customTab3" label="After Help" insertAfterMso="HelpTab"/>
            </
    tabs>
        </
    ribbon>
    </
    customUI
    Cheers
    Andy

    www.andypope.info

Tags for this Thread

Posting Permissions

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