Developer Ribbon

 

Advanced Excel Objectives

In this lesson, you will learn how to:

1. Use the Developer Ribbon to record, save and run a simple Event Macro.

2. Modify a Macro with the Visual Basic Editor.

3. Create a custom Macro Button and assign it to the Quick Access Toolbar.

4. Run a Macro when a workbook is opened.

5. Copy the Macro from one spreadsheet to another.

Menu Map
 
 

Lesson 7 : Introduction to Macros

 

   
Home Ribbon
Menu Map

More Menu Maps

From the Backstage

1. File ->Options-> Customize Ribbon, page 262

2. File ->Save As Macro Enabled, page 269

3. File->Info->Enable Content, page 271

4. File ->Options->Trust Center, page 273

Menu Maps

From the Developer Ribbon.

1. Developer ->Code-> Record Macro, page 251

2. Developer ->Code-> Macros, page 254

3. Developer ->Code-> Visual Basic, page 255

4. Developer ->Code->Macro Security, page 271

From the Home Ribbon.

5. Home ->Editing->Find&Select, page 252