Excel 2016 Macros

Excel 2016

Lesson 3 – Editing Macros

NOTE To use the Developer tab, you should ensure that the Show Developer in the Ribbon option is selected. This option is located in the Popular page of the Excel Options dialog box.



P ROCEDURES

1. Display the Developer tab on the Ribbon .

2. Select in the Code group. 3. Display or insert the module in which you want to write the new macro. 4. Resize or maximize the Code window, as desired. 5. Position the insertion point above or below any existing macros in the Code window. 6. Type Sub . 7. Press [Spacebar] . 8. Type the macro name, followed by a set of parentheses ( ( ) ). 9. Press [Enter] .



S TEP - BY -S TEP From the Student Data directory, open CITY57.XLSM . Write a new macro.

If necessary, enable the macros.

Steps

Practice Data

1. Display the Developer tab on the Ribbon . The Developer tab is displayed. 2. Select the Visual Basic button in the Code group. The Visual Basic Editor opens. 3. Display or insert the module in which you want to write the new macro. The desired module Code window is displayed.

Click Developer

Click

Double-click Module1 in the Project Explorer task pane, if necessary

OFFICEPRO, Inc.

Page 43