Author: Oscar Cronquist Article last updated on April 11, 2018

The Quick Access Toolbar is located at the very top of your Excel window, I highly recommend that you place your most used commands and macros there.

Here are the steps needed to create a macro button on the Quick Access Toolbar:

  1. Press with left mouse button on the rightmost button on the Quick Access Toolbar to customize the Quick Access Toolbar
  2. Press with left mouse button on "More Commands..." button.
  3. Press with left mouse button on the left drop down button
  4. Select "Macros"
  5. Select Macro1
  6. Press with left mouse button on "Add >>" button
  7. Press with left mouse button on "Modify"
  8. Pick an icon for your macro.
  9. Press with left mouse button on OK button
  10. Press with left mouse button on OK button

The picture below shows the new button on the Quick Access Toolbar. Press with left mouse button on it to launch macro1.

The following post demonstrates how to save your macros in a personal Excel file so you can use your macros in any workbook you have open:

Recommended articles

Customize the ribbon and how to add your macros
Save links to your favorite macros in a personal tab on the ribbon for easy access and become more productive. […]