Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

Steps

Practice Data

4. Select Macros .

Click Macros

A list of available macros is displayed in the Commands list.

5. 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.

6. Select the name of the workbook in which the macro is stored. The workbook name appears in the Customize Quick Access Toolbar box. 7. Select from the Commands list, if desired. The is selected. The is added to the Customize Quick Access Toolbar For CITY60.XLSM list. 9. Select the desired macro from the Commands list. The macro name is selected. The macro is added to the Customize Quick Access Toolbar For CITY60.XLSM list. 11. Continue adding macros to the QAT , as desired. The macros are added to the Customize Quick Access Toolbar For CITY60.XLSM list. 8. Select the Add button. 10. Select the Add button.

Click For CITY60.XLSM

Click

Click

Click Company

Click

Follow the instructions shown below the table before continuing to the next step

12. Select OK .

Click

The Excel Options dialog box closes and the macro buttons and separator appear in the Quick Access Toolbar .

Add the Urban_Update macro to the Quick Access Toolbar For CITY60.XLSM.

Page 72

OFFICEPRO, Inc.