Adding a Macro to the Quick Access Toolbar - Exercise

Contact Us or call 1-877-932-8228
Adding a Macro to the Quick Access Toolbar - Exercise

Adding a Macro to the Quick Access Toolbar

Duration: 5 to 10 minutes.

In this exercise, you will add a macro to the Quick Access Toolbar.

  1. Open Add Macros to QAT.xlsm from your Excel2013.3/Exercises folder.
  2. Add the macro named "CustomHF" to the Quick Access Toolbar.

Solution:

  1. Click the Customize Quick Access Toolbar drop-down arrow:Customize Quick Access Toolbar
  2. Select More Commands:More Commands
  3. In the Excel Options dialog box on the Quick Access Toolbar tab, from the Choose commands from drop-down list, select Macros:Macros Command
  4. Select the macro named "CustomHF" to add it to the Quick Access Toolbar and click Add and then OK:Add Command
  5. You can now see and run the macro on the Quick Access Toolbar:Run the Macro
Next