Macro and custom Button

[Guest]

Hello Last year I created a macro and assigned custom button to the macro.
I have to edit this macro and I forgot the name of the macro. How do I find
out which macro is attached to this custom button/ Thanks

 

[Guest]

Try: right click on the button and then "Assign Macro": this should show
which macro is currently assigned.

 

[Guest]

Toppers THanks but If I right clik on the button I get a menu with tool
bars names , e.g. standard, formatting, borders, chart, nothing that says
"Assign macro"

 

[Guest]

Sorry ... I now realise your button is on a toolbar. Looking through my Excel
"Bibles" I cannot see any obvious way to determine the macro although I guess
this can be done (somehow!) using VBA.

What happens (or should) when you click your button - can you cause it to
fail and use this to identify the macro? A bit crude but might work!

 

[Guest]

use <view><toolbars><custom>
now when you right click on the button it will show the assign macro line