Whats behind the macro button?

[Kerry]

Hi
I have created a custom toolbar, with buttons to run a
number of macros. I have customised the pictures and the
text but now cannot tell which button will run which
macro!!

Can anyone advise on a way to work this out please??

Thanks very much.

 

[Jonathan West]

Hi Kerry,

Suppose you have a toolbar called Custom, you can type the folloign into the
immediate window in the VBA editor, and get the module and macro name of the
macro the button is attached to.

? Commandbars("Custom").Controls(1).OnAction

Change the number 1 to 2 for the second button on the control etc.

Unfortunately, there is no way of getting the information through the user
interface, as far as I know.

 

[Larry]

If you hold the mouse over a macro button on a toolbar (though not a
macro button on a menu), the true name of the macro will be displayed in
a popup.

Larry

 

[Lars-Eric Gisslén]

Larry,

Unless you have changed the tooltip to something more descriptive for the
user.