Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons



P ROCEDURES

1. Select the Customize Quick Access Toolbar button to the right of the Quick Access Toolbar . 2. Select More Commands . 3. Select the Choose commands from list . 4. Select Macros . 5. If the macro is stored in a specific workbook, select the Customize Quick Access Toolbar list . 6. Select the name of the workbook in which the macro is stored. 7. Select from the Commands list, if desired.

8. Select . 9. Select the desired macro from the Commands list. . 11. Continue adding macros to the QAT , as desired. 10. Select

12. Select

.



S TEP - BY -S TEP Add a macro to the Quick Access Toolbar .

If necessary, enable the macros.

Steps

Practice Data

1. Select the Customize Quick

Click

Access Toolbar button to the right of the Quick Access Toolbar . The Customize Quick Access Toolbar menu opens.

2. Select More Commands .

Click More Commands

The Excel Options dialog box opens with the Customize page displayed. 3. Select the Choose commands from list. A list of available options is displayed.

Click Choose commands from

OFFICEPRO, Inc.

Page 71