Add a Macro to the Toolbar

 

If you use an Excel macro frequently, you can add it to the Quick Access Toolbar. This way you can quickly access your macro. First, we record an empty macro.

1. On the Developer tab, click Record Macro.

Click Record Macro

2. Name the macro MyName. Choose to store the macro in Personal Macro Workbook. This way the macro will be available to all your workbooks (Excel files). This is possible because Excel stores your macro in a hidden workbook that opens automatically when Excel starts.

Store Macro in Personal Macro Workbook

3. Click Stop Recording.

Click Stop Recording

4. Open the Visual Basic Editor.

5. Create the macro:

Create the Macro

This macro places your name in the Active Cell.

6. Now we can add this macro to the Quick Access Toolbar. Right click the Quick Access Toolbar and select Customize Quick Access Toolbar.

Customize Quick Access Toolbar

7. Under Choose commands, select Macros.

8. Select the macro and click Add.

Add Macro

9. You can modify the button that will be added to the Quick Access Toolbar by clicking on Modify. For example, choose a smiley.

Modify Button

10. Click OK.

11. You can now execute the macro by clicking on the smiley button added to the Quick Access Toolbar.

Result:

Quickly Access the Macro

12. When you close Excel, Excel asks you to save the changes you made to the Personal Macro Workbook. Click Save to store this macro in a hidden workbook that opens automatically when Excel starts. This way the macro will be available to all your workbooks (Excel files).

Save Changes to the Personal Macro Workbook

Do you like this free website? Please follow us on Google+