What macro is run by a button???

  • Thread starter Thread starter Lee Johnson
  • Start date Start date
L

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
 
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)
 
Back
Top