What macro is run by a button???

[Lee Johnson]

Gang,
There is a little smiley face button put on the toolbar at one of our
computers that runs a macro when pressed. How can we find out which macro
is being run????

Thanks
Lee Johnson

 

[Peo Sjoblom]

One way,

right click on any tool bar (or do tools>customize) and select customize,
right click on the button and select assign macro,
in the name of the macro is in the name box. For instance if the macro is
stored in the personal.xls the name would look like

PERSONAL.XLS!macroname

now when you know where it is stored you can press Alt + F11 to open the
VBE, select the workbook and double click the
modules folder in the project pane to the left, then double click the module
itself and the code will be there

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

you can also get to the code by right clicking the button> Assign Macro>Edit