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. 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.
how to add a macro to your Quick Access toolbar in Excel

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

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

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

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

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

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


Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

2 Comments
  1. Reply
    jaypogi September 30, 2016 at 4:18 AM

    wonderful i’m learning quite a lot thank you so much!!!

    • Reply
      Kawser October 4, 2016 at 7:48 PM

      Thank you, Jaypogi!

    Leave a reply