Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

The Visual Basic Editor window

NOTE If the Project Explorer or the Properties Window is not open in the Visual Basic Editor window, you can click the Project Explorer or Properties Window button on the Standard toolbar in the Visual Basic Editor window to open them. You can also select the View menu and choose Project Explorer or Properties Window . You can also open any Code window from the View menu but you must first select the name of the Object or Module in the Project Explorer. The Visual Basic Editor window can also be opened by pressing the [Alt+F11] key combination. You can use the [Alt+F11] key combination to toggle between Excel and the Visual Basic Editor. To close the Visual Basic Editor window, select the File menu and click Close and Return to Microsoft Excel . You can also use the Close button at the right-hand end of the Title bar in the Visual Basic Editor window.



P ROCEDURES

1. Open a workbook containing macros and enable the macros. 2. Select the Developer tab.

Page 22

OFFICEPRO, Inc.