-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro Button
- Thread starter sohaibj
- Start date
Hi sohaibj
Go Tools -> Customise and select the "Commands" Tab. Then choose the "Macros" option in the left hand window. You will see two opions, one with a picture of a smily face and one without. Choose one and click-and-Drag it to the toolbar. Then rightClick it and at the bottom of the list that you will see is an option to "Assign a Macro". Select it and your macros list will pop up. Select your macro and close the "Customise" Window. You can add a picture to your toolbar button, or give it a name etc.
There you are as easy as that.
anvil19
Go Tools -> Customise and select the "Commands" Tab. Then choose the "Macros" option in the left hand window. You will see two opions, one with a picture of a smily face and one without. Choose one and click-and-Drag it to the toolbar. Then rightClick it and at the bottom of the list that you will see is an option to "Assign a Macro". Select it and your macros list will pop up. Select your macro and close the "Customise" Window. You can add a picture to your toolbar button, or give it a name etc.
There you are as easy as that.
anvil19
Similar threads
- Solved
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
