Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

Select the Modify button and click on the multisheet symbol (row 10, column 5). Change the Display name text to Consolidate the latest sales data . Click OK to close the Modify Button dialog box, then click OK to close the Excel Options dialog box.

Click the Consolidate the latest sales data button on the Quick Access Toolbar.

D ELETING A M ACRO B UTTON FROM THE QAT  D ISCUSSION

You can remove a button easily from the Quick Access Toolbar if you no longer use it. If the button is attached to the Quick Access Toolbar for a specific workbook, the workbook must be open to remove the button. When you delete a macro button from the Quick Access Toolbar , only the button is deleted; the macro remains available and can be viewed and edited in the Visual Basic Editor or run from the Macros button in the View or Developer tab.  P ROCEDURES 1. Right-click the button on the Quick Access Toolbar that you want to remove. 2. Select Remove from the Quick Access Toolbar .  S TEP - BY -S TEP Delete a macro button from the Quick Access Toolbar .

Steps

Practice Data

1. Right-click the button on the Quick Access Toolbar that you want to remove.

Right-click

The Quick Access Toolbar shortcut menu appears.

2. Select Remove from the Quick Access Toolbar . The selected button is removed from the Quick Access Toolbar .

Click Remove from the Quick Access Toolbar

Practice the Concept: Right-click on the Insert company name in current cell macro button and select Remove from the Quick Access Toolbar from the shortcut menu. Then, right-click on the Separator and remove it from the Quick Access Toolbar. Close CITY60.XLSM.

Page 76

OFFICEPRO, Inc.