How to add a macro to your Quick Access toolbar in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.

You can also assign a macro to a button on your Quick Access toolbar:

1. 1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar from the shortcut menu. The Quick Access Toolbar tab of the Excel Options dialog box appears.

Right-click on the Quick Access Toolbar and select Customize Quick Access Toolbar… option from the shortcut menu appears.

1. Select Macros from the drop-down list on the left.
2. At the top of the list on the right, choose For All Documents, or For xxx (where xxx is the active workbook’s name). This step determines whether the macro will be available for all workbooks, or just the workbook that contains the macro.
3. Select your macro and click the Add button.
4. To change the icon or displayed text, click the Modify button.

Step by step process to add a macro to Quick Access Toolbar

Step by step process to add a macro to the Quick Access toolbar with the modified button.

After performing these steps, your Quick Access toolbar will display a button that executes your macro like the following figure.

The Green Square box is denoting the TimeStamp macro in the Quick Access Toolbar.

Download Working File

Time-Stamp.xlsm

Happy Excelling 🙂

Read More…

How to Assign a Macro to a Button in Excel

How to customize the Quick Access Toolbar