Identify Macro running from a custom button on the Ribbon Bar

[Graebeard]

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

 

[Fluff]

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.

 

[DataBlake]

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/mi...n-and-the-quick-access-toolbar-in-excel-2013/

 

[Fluff]

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