Macro and custom Button
use <view<toolbars<custom
now when you right click on the button it will show the assign macro line
"Toppers" wrote:
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!
"Wanna Learn" wrote:
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"
"Toppers" wrote:
Try: right click on the button and then "Assign Macro": this should show
which macro is currently assigned.
"Wanna Learn" wrote:
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
|