Excel 2016 Macros

Table of Contents

ABOUT OFFICEPRO – WE CHANGE LIVES! ...............................................................I

WHAT TO EXPECT FROM OFFICEPRO?...................................................................II

TABLE OF CONTENTS...........................................................................................III

LESSON 1 -

USING MACROS .............................................................................5 Defining Macros .......................................................................................................6 Changing Macro Security Settings............................................................................7 Adding a Folder as a Trusted Location ...................................................................10 Opening a Workbook Containing Macros ..............................................................14 Running a Macro ....................................................................................................16 Using a Shortcut Key...............................................................................................18 Displaying the Developer Tab.................................................................................19 Opening the Visual Basic Editor Window ...............................................................21 Using the Visual Basic Editor Window....................................................................23 Exercise...................................................................................................................26 RECORDING MACROS...................................................................27 Recording a Macro .................................................................................................28 Assigning a Shortcut Key ........................................................................................32 Using Relative References ......................................................................................34 Deleting a Macro ....................................................................................................37 Exercise...................................................................................................................40 EDITING MACROS ........................................................................41 Writing a New Macro .............................................................................................42 Entering Macro Comments ....................................................................................44 Copying Macro Commands ....................................................................................47 Editing Macro Commands ......................................................................................49 Typing Macro Commands.......................................................................................51 Running a Macro from the Code Window..............................................................53 Exercise...................................................................................................................56

LESSON 2 -

LESSON 3 -

LESSON 4 -

CREATING MACRO BUTTONS........................................................59

OFFICEPRO, Inc.

Page iii