Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

5. To open the Properties Window task pane, select the Properties Window button on the Standard toolbar. 6. To close a maximized Code window, select its Close button at the right-hand end of the Menu bar. 7. To expand an item in the Project Explorer task pane, select the plus sign to the left of the item. 8. To open the Code window for a Module, double-click the module name.  S TEP - BY -S TEP Use the Visual Basic Editor window.

If necessary, enable the macros and open the Visual Basic Editor window.

Steps

Practice Data

1. Select the Close button on the Title bar of the Project Explorer task pane. The Project Explorer task pane closes. 2. Select the Project Explorer button on the Standard toolbar. The Project Explorer task pane opens. 3. Select the Close button on the Title Bar of the Properties Window task pane. The Properties Window task pane closes. 4. Select the Properties Window button on the Standard toolbar. The Properties Window task pane opens. 5. Select the Code window Close button. The Code window closes. 6. Select the plus sign to the left of the Modules folder in the Project Explorer window. The folder expands to display its contents. 7. Double-click the module you want to display. The Code window opens with the contents of the module displayed.

Click on the Project Explorer task pane

Click

Click on the Properties Window task pane

Click

Click at the right-hand end of the Menu bar

Click to the left of

Double-click Module 1

Page 24

OFFICEPRO, Inc.