+ Reply to Thread
Results 1 to 5 of 5

Custom screentip and supertip for custom button in the ribbon

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Custom screentip and supertip for custom button in the ribbon

    Hello friends!

    I am trying to add a custom screentip and supertip to a button I've added to a custom Tab.
    This tab is always present, not only when I open the file that holds the code.

    Capture1.PNG

    Is there a way to do something like:

    Capture2.PNG


    Thank you!
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,979

    Re: Custom screentip and supertip for custom button in the ribbon

    I think you have to use CustomUI for that, which would be in the file with the code. That would mean that the tab only shows up when that workbook is loaded - not sure if that is what you want?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Custom screentip and supertip for custom button in the ribbon

    Actually no, I have customized the ribbon (File - Options - Customize Ribon) so the ribbon is modified permanently (as it should). This way I can apply the code to any file.
    CustomUI let me modify the tips but only file-wide, not excel-wide, hence my question.. is it possible to edit these tips for permanently ribbon customization (excel-wide)?

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,979

    Re: Custom screentip and supertip for custom button in the ribbon

    Not as far as I know, but what's the point in having the button without the file being loaded, when the code needs the file loaded to run? If you make the code file into an add-in, then it would seem to solve all the problems.

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Custom screentip and supertip for custom button in the ribbon

    Okay, I have made the add-in and imported into QAT but the problem remains.. How do I edit this QAT button tips?

    LE:


    I got it!
    The infos about this button stays in a file Excel.officeUI that can be found in C:\[user]\AppData\Local\Microsoft\Office
    I have added the screentip="Color Button" supertip="Select an area first!" params and now it is working.

    Capture3.PNG

    Thank you much!
    Last edited by bulina2k; 05-21-2024 at 09:19 AM. Reason: solved!

+ 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. Add Supertip to Custom Ribbon Group?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-06-2017, 03:58 AM
  2. [SOLVED] Macro runs using F5 but not when clicking custom button on ribbon
    By 6StringJazzer in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2017, 09:39 AM
  3. Dropdown box in a custom ribbon on click of button
    By benwilson6215 in forum Excel General
    Replies: 0
    Last Post: 07-07-2017, 10:21 AM
  4. Custom Ribbon button color ??
    By Rmag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2016, 12:50 PM
  5. 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
  6. [SOLVED] Run Logon button under custom ribbon tab using VBA
    By v2k2apj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 04:09 PM
  7. Custom ribbon button will not check checkboxes
    By ericsastud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2010, 03:43 PM

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