To determine what macro is assigned to a button:

1. Click the button with the  Right  mouse button
    A shortcut menu appears

2. Click on  Assign Macro
    The Assign Macro dialog box appears

3. The macro assigned to the button is displayed in the 
     Macro Name/Reference box
 

To GoTo the macro:

3.  Click on the Edit  button
     Do so after steps 1 & 2 above are completed
 

To Change the macro assigned to a button:

1.  Complete steps 1 & 2 above

2.  Find the new macro in the list, then click on the macro name

3.  Click OK  (or double click on the macro name in step 2)

If you rename a macro, these steps will be required for the button 
to activate the new macro name.
 
 
 

Comments:

This article applies to Excel 5, Excel 7 (95), Excel 97 and Excel 2000..

Macros can be attached to many different types of objects, not just the regular macro button most commonly used. The steps listed here are basically the same, how different steps may be needed to get the object into a mode in which it can be edited.  For example, to attach or edit a macro assigned to a toolbar button, first Click on View (in the menu), Toolbars, Customize. From here, the button will work as described above.
 
 
 
 
 
 
 

Related Articles:

Editing or Viewing a Recorded Macro