View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to identify macro assigned to toolbar button

When in customize mode right-click on the button and "assign macro"

You should get the macro dialog with the assigned macroname in the refedit
box.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 17:32:01 -0700, Patricia D
wrote:

How can I identify what macro is currently assigned to each button on a
custom toolbar?

I am trying to troubleshoot a workbook writtten by someone else. 'Sub'
names do not match button text; many buttons, many macros.

Using Customize, I can see how to modify assigned macro, but don't see how
to check what currently assigned macro is.