How to Create a Toolbar Button for an Existing Macro
1. Go to Start>Programs>Microsoft Excel to open the application. Go to File>New and open a new spreadsheet.
2. Go to Tools>Customize and select it.
3. A pop-up menu window called “Customize” will appear, click on the “Toolbar” tab and select the toolbar where you want the macro button to appear. For this tutorial, we want the macro button to be accessible and visible in the “Standard” toolbar, so check the box for the Standard toolbar.
4. Now click on the “Commands” tab and select a category – the kind of function you will be creating as a button. Go down and select “macros.” The Commands window to the right of the pop-up window appears with two options: Custom Menu Item or a Custom Button.
5. Click on the “Custom Button” (it looks like a happy face) option and drag it to the standard toolbar (located at the top of the screen under the different menu options - File, Edit, etc.), place it right next to the “Save” button so it is easy to locate.
6. Now click on the new macro button and a pop-up window called “Assign Macro” will appear. Here select the actual macro that will be assigned to this button, so for this tutorial we’ll use one already created called “PERSONAL.XLS!.ht” macro and hit OK.
7. Finally, we’ll test the new custom macro button. Go to File>New to open a new spreadsheet, and click on the newly created macro button located on the standard toolbar to the right of the “Save” button. After clicking the button, you will see the names of ten training managers automatically appear.
Great! wasn’t it super easy. You can basically follow the same steps to add a button for any function other than a macro. Remember to keep practicing because the more you do it, the better you will get.
