View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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