Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

3. Select

in the Code group.



S TEP - BY -S TEP Open the Visual Basic Editor window.

If necessary, enable the macros and show the Developer tab in the Ribbon .

Steps

Practice Data

1. Select the Developer tab. The Developer tab is displayed.

Click Developer

2. Select the Visual Basic button in the Code group. The Visual Basic Editor window opens.

Click

Practice the Concept: Maximize the Module 1 Code window. Press [Alt+F11] to switch to the Excel window. Then, display the Visual Basic Editor window again.

U SING THE V ISUAL B ASIC E DITOR W INDOW  D ISCUSSION

The Visual Basic Editor window displays the Project Explorer window, the Properties window, and the Code window. Each of these windows can be opened and closed independently. When a closed window is reopened, it opens at its previous size and location.

NOTE You can also press the [Ctrl+R] key combination to open the Project Explorer window, the [F4] key to open the Properties window, and the [F7] key to open the Code window.



P ROCEDURES 1. Open a workbook containing macros and enable the macros.

2. To close the Project Explorer task pane, select the Close button on theTitle bar. 3. To open the Project Explorer task pane, select the Project Explorer button on the Standard toolbar. 4. To close the Properties Window task pane, select the Close button on its Title bar.

OFFICEPRO, Inc.

Page 23