| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
What macro is run by a button???
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
What macro is run by a button???
One way,
right click on any tool bar (or do toolscustomize) 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) "Lee Johnson" wrote in message 8.18... 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 |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
What macro is run by a button???
you can also get to the code by right clicking the button Assign MacroEdit
"Peo Sjoblom" wrote: One way, right click on any tool bar (or do toolscustomize) 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) "Lee Johnson" wrote in message 8.18... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
| Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
| Can't select macro button after other button is pressed | Excel Programming | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
| How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
Linear Mode
