Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

NOTE You can unhide hidden workbooks, such as the Personal Macro Workbook , by selecting the Unhide button in the Window group on the View tab. If Unhide is unavailable, then the workbook does not contain hidden workbook windows. If you delete a macro from the Personal Macro Workbook , Excel prompts you to save the changes to the Personal Macro Workbook when you exit Excel. You can also open the Macro dialog box by selecting the bottom part of the Macros button on the View tab and then clicking View Macros .



P ROCEDURES 1. Open the workbook containing the macro you want to delete and enable the macros. 2. Select the Developer tab on the Ribbon .

3. Click in the Code group. 4. Select the macro you want to delete from the Macro list. 5. Select .

6. Select

.



S TEP - BY -S TEP

Delete a macro.

If necessary, enable the macros.

Steps

Practice Data

1. Select the Developer tab on the Ribbon . The Developer tab is displayed. 2. Click the Macros button in the Code group. The Macro dialog box opens.

Click Developer , if necessary

Click

Page 38

OFFICEPRO, Inc.