Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016



P ROCEDURES

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

6. Select . 7. Select the desired button image. 8. Select the text in the Display name box. 9. Type the desired display name for the macro button.

10. Select

.

11. Select

.



S TEP - BY -S TEP

Change a button image.

If necessary, enable the macros in the workbook.

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. If the macro is stored in a specific workbook, select the Customize

Click Customize Quick Access Toolbar

Quick Access Toolbar list. A list of open workbooks is displayed.

Page 74

OFFICEPRO, Inc.