Results 1 to 4 of 4

Thread: Identify Macro running from a custom button on the Ribbon Bar

  1. #1
    New Member
    Join Date
    Mar 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Identify Macro running from a custom button on the Ribbon Bar

    Hi folks,

    I added a number of buttons to my ribbon bar but can't recall the name of one of the attached macros. On a regular form button, you can just right click to Assign Macro and the current one is shown. However, the button bar does not allow this approach. Any ideas how I can identify the currently attached macro?

    Thanks
    Graebeard

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,198
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Identify Macro running from a custom button on the Ribbon Bar

    If you go into "Customise Ribbon" & expand the section with your buttons, then you can just hover the cursor of the button & it will tell you the name of the macro.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular BlakeSkate's Avatar
    Join Date
    Jan 2015
    Location
    Pernsylvoonia
    Posts
    468
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Identify Macro running from a custom button on the Ribbon Bar

    if you added a macro to the ribbon bar the name should appear as the macro name
    unless you're talking about the quick access bar?
    in which case you can just hover the button and it should display the name of the assigned macro as a tooltip or something
    check out this article which explains adding both instances of buttons

    https://www.dummies.com/software/mic...in-excel-2013/
    -------------------------------------------------------------------------------
    I may not give the best VBA codes, but they sure are VBA codes.
    Help me help you by posting a snapshot of your data & your expected result
    Please use [ code][ /code] tags when posting VBA as well as proper indentation

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,198
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Identify Macro running from a custom button on the Ribbon Bar

    Quote Originally Posted by BlakeSkate View Post
    if you added a macro to the ribbon bar the name should appear as the macro name
    Not if you've renamed it
    Also the tooltip for the QAT will show the name of the button, not necessarily the name of the macro
    Last edited by Fluff; Sep 16th, 2019 at 05:46 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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