© 2019 Nightwing Consulting & Rhonda Williams Byrd

Macros Outline

 

Lesson 1 -  Using Macros

Defining Macros

Changing Macro Security Settings

Adding a Folder as a Trusted Location

Opening a Workbook Containing Macros

Running a Macro

Using a Shortcut Key

Displaying the Developer Tab

Opening the Visual Basic Editor Window

Using the Visual Basic Editor Window

Lesson 2 -  Recording Macros

Recording a Macro

Assigning a Shortcut Key

Using Relative References

Deleting a Macro

Lesson 3 -  Editing Macros

Writing a New Macro

Entering Macro Comments

Copying Macro Commands

Editing Macro Commands

Typing Macro Commands

Running a Macro from the Code Window

Lesson 4 -  Creating Macro Buttons

Using a Macro Button

Creating a Macro Button

Copying a Macro Button

Formatting a Macro Button

Moving/Sizing a Macro Button

Deleting a Macro Button

Adding a Macro to the Quick Access Toolbar

Changing a QAT Macro Button Image

Deleting a Macro Button from the QAT

 

Lesson 5 – Creating Macros in a Database

Working with Macros in a Database

Opening the Macro Tools Window

Creating a Macro

Displaying Macro Design Arguments

Assigning an Argument to an Action

Saving a Macro

Using Single Step Mode for Testing

Running a Macro

Editing an Existing Macro

Lesson 6 – Using Macros in a Database

Using Properties

Assigning a Macro to a Control

Creating a Command Button

Adding a Condition to a Macro

Creating a Group Macro

Creating an Autoexec Macro