spot_img

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 OK.

4. Click Stop Recording.

Click Stop Recording

5. Open the Visual Basic Editor.

6. Create the macro:

Create the Macro

This macro places your name in the Active Cell.

7. Close the Visual Basic Editor.

8. Now we can add this macro to the Quick Access Toolbar. Click the down arrow and click More Commands.

Customize Quick Access Toolbar

9. Under Choose commands, select Macros.

10. Select the macro and click Add.

Add Macro

11. 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

12. Click OK twice.

13. You can now execute the macro. For example, select cell E2 and click on the smiley button added to the Quick Access Toolbar.

Result:

Quickly Access the Macro

14. 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

spot_img
Previous articleRolling Average in Excel VBA
Next articleHow to create a Refresh All button in Excel