Tool Bar Button
Revision as of 11:25, 12 March 2008 by imported>Bob
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.