Tool Bar Button
Jump to navigation
Jump to search
So, you've made an Excel macro and now you want to access it from the main tool bar...
Here's what you'll need to do:
- From Excel, Right-Click on the toolbar
- Select 'Customize' listed at the bottom of the pop-up menu
- Select the 'Commands' middle tab from the 'Customize' window
- Select 'Macros' from the 'Categories' text box with a slider on the left side of the window
- Select a 'Custom Button' from the 'Commands' pane and drag it up to your toolbar
- Right click on the new button you've put on the toolbar and select 'Assign Macro' from the bottom of the pop-up menu
- You can also change the name of the button and the button figure from this pop-up menu.
- When you're done close the 'Customize' window.