+ Reply to Thread
Results 1 to 11 of 11

Add Supertip to Custom Ribbon Group?

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Add Supertip to Custom Ribbon Group?

    I want to add a Supertip to a custom group on a custom tab on my Ribbon. Although the XML code validates, it doesn’t display when I mouse over the group name

    Can groups have Supertips? I’ve found conflicting views on this point. Also, what is the property on a System tab/group –such as Home/Alignment that creates the little square in the bottom right corner of the Alignment group that opens a pop-up when you mouse over it? Can that property be added/customized in a custom XML group? Thanks for reading.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add Supertip to Custom Ribbon Group?

    I also have problems with the SuperTips so I quit trying. I use the ScreenTips and they do enough for me
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

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

    Re: Add Supertip to Custom Ribbon Group?

    The group doew not have screen tip or supertip attributes.

    The button in button right hand corner is a dialogue launcher, which can have screen and super tip text.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Re: Add Supertip to Custom Ribbon Group?

    Thanks Andy for the reply and especially for the code. The dialogBoxLauncher works better than what I had planned originally!

    I cannot find anything about the QAT relative to a supertip attribute – so I’m assuming it does not. Can you confirm if that assumption is correct?

  5. #5
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Re: Add Supertip to Custom Ribbon Group?

    Keebellah – Thanks for the info. If you still have interest in SuperTips, you should check out the file Andy posted.

    Also I had found this explanation if you want to put hard returns into your Supertips. https://social.msdn.microsoft.com/Fo...ips?forum=vsto

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

    Re: Add Supertip to Custom Ribbon Group?

    You can add a button with tip texts to the QAT. Be aware the ribbonx for the QAT requires startfromscratch to be set.

    If you add a button to the QAT using the built-in customization then only the macro name will be shown.

  7. #7
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Re: Add Supertip to Custom Ribbon Group?

    Andy, thanks for the additional information – I had to do a little research to ask some (hopefully) intelligent follow- questions. While at this level of Excel customization I’m punching above my weight, I can generally get things to work.

    Currently I have perhaps a somewhat bastardized QAT – half system and half custom. The custom half is based on a file called “OneworkbookQAT.xlam” Below is a picture of my existing custom ribbon and custom QAT. I understand the part of the ribbon created using the built-in customization will only display the macro name on mouse over. But your first sentence regarding “tip texts” seems to suggest I can do more with the custom QAT part. I had to look up “startfromscratch” since I didn’t need it to create the QAT I have. From what I’ve read, using that command would require me to build the entire ribbon from scratch – true?

    I remember customizing the XML for the custom ribbon part what more convoluted – I couldn’t use a UI editor, it was just a text file that was one long string (I can find that in my notes). But do you know if such QAT customization would allow something other than the file name displayed? (Without completely rebuilding my entire ribbon).

    Finally, is “tip texts” an actual term or are you just referring to screen tips/supertips in a generic form? I couldn’t find “tip texts”

    Thanks again for your help.

    QAT.png

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add Supertip to Custom Ribbon Group?

    Take look here and check it out.
    It helped me
    https://www.rondebruin.nl/win/section2.htm

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

    Re: Add Supertip to Custom Ribbon Group?

    I was able to modify the exported customUI text, modify it and import it again. The downside to this approach is if you share this with other users you will wipe out their customisation.

    <mso:button idQ="x1:Book1_MyRoutine_1" visible="true" label="MyRoutine" imageMso="ListMacros" onAction="Book1!MyRoutine" screentip="My screen tip" supertip="My super tip"/>
    "tips text" was just short hand for both types of tip text.

    If you use startfromscratch you can rebuild the ribbon quite easily by simply making the built in groups visible. Once the group is visible all groups and controls within it are functional

  10. #10
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Re: Add Supertip to Custom Ribbon Group?

    "If you use startfromscratch you can rebuild the ribbon quite easily by simply making the built in groups visible. Once the group is visible all groups and controls within it are functional"

    Thanks for the info Andy - that sounds simple enough. Question - using startfromscratch allows me to have both a completely custom ribbon and QAT (if I understand you correctly). Regarding the ribbon, is there a downside to have a completely custom ribbon vs. adding one custom tab to the standard Excel ribbon as I've currently have? With startfromscratch is the QAT still a separate file or is it somehow incorporated into the new ribbon file? Thanks.

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

    Re: Add Supertip to Custom Ribbon Group?

    If you startfromscratch you can have custom tab, reapply built-in tabs and add to QAT.

    It depends on the functionality required when using the add-in. If you only need a basic set of controls to allow user to provide input information and invoke routines then a single custom tab is ideal.
    If they need to format worksheet whilst using the add-in then it makes sense to include built-in functionality, whether that means exposing the whole tab or building your own with built-in groups is a choice you need to make.

    Personally I would not add things to the QAT. This is the area that the user controls and is limited in amount of content.

+ 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. Custom Ribbon Tabs without Custom UI tool
    By edmunda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2016, 04:39 AM
  2. Put VBA ribbon together with Custom UI Editor Ribbon
    By czarlando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2016, 05:46 AM
  3. Ribbon With a group and a macro that disappears
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2015, 02:29 PM
  4. 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
  5. [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
  6. [SOLVED] Unable to remove new group from ribbon
    By gnomad in forum Excel General
    Replies: 6
    Last Post: 07-25-2012, 03:56 AM
  7. Customised ribbon - displaying a group based on pressing a button in another group
    By micklloyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2012, 03:55 PM

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