+ Reply to Thread
Results 1 to 3 of 3

How to see what macro is assigned to ribbon button

  1. #1
    Registered User
    Join Date
    07-28-2008
    Location
    New York
    Posts
    12

    How to see what macro is assigned to ribbon button

    I need to see what macro is assigned to a button on a custom ribbon.

    I used to be able to right-click the button and use the 'Assign Macro' option, but that option no longer exists. I only have Add to Quick Access Toolbar, Hide Quick Access Toolbar, Customize the Ribbon and Collapse the Ribbon.

    I've seen other posts that use a VBA scrip, but that only works on command buttons within a workbook and my buttons are on the ribbon.

    Any suggestions?
    -Quercus

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to see what macro is assigned to ribbon button

    There is not a great way to do this. Right click on the ribbon to bring up the Customize the Ribbon dialog. Then hover the cursor over the button name and after a second or two you will get a little tool tip with a path to the macro.

    Find macro associated with button.jpg
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-28-2008
    Location
    New York
    Posts
    12

    Re: How to see what macro is assigned to ribbon button

    That worked, thanks.

+ 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. Replies: 1
    Last Post: 02-07-2018, 03:25 PM
  2. Macro assigned to button does not stay assigned
    By tuscan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2017, 02:22 AM
  3. How to know what macro assigned to the button
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2017, 04:11 AM
  4. Creating a log using a macro assigned button
    By cudoig in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2013, 02:51 PM
  5. Knowing what Macro was assigned to a Button
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 05-13-2010, 04:30 PM
  6. Macro assigned to a button
    By rmanthorpe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2006, 07:22 AM
  7. [SOLVED] How do I know what macro is assigned to a button?
    By Denise in NC in forum Excel General
    Replies: 3
    Last Post: 04-03-2006, 09:35 AM

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