1 / 27

Excel Lesson 14 Creating and Using Macros

Excel Lesson 14 Creating and Using Macros. Microsoft Office 2010 Advanced. Cable / Morrison. Objectives. Understand macros. Review macro security settings. Record a macro. Save a macro as a macro-enabled workbook. Run a macro. 2. 2. Objectives (continued). Edit a macro.

Download Presentation

Excel Lesson 14 Creating and Using Macros

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Excel Lesson 14Creating and Using Macros Microsoft Office 2010 Advanced Cable / Morrison

  2. Objectives • Understand macros. • Review macro security settings. • Record a macro. • Save a macro as a macro-enabled workbook. • Run a macro. 2 2

  3. Objectives (continued) • Edit a macro. • Create a button. • Align and format a button. • Open a macro-enabled workbook.

  4. Vocabulary • button • code • macro • virus 4 4

  5. Introduction • A macroautomates a common, repetitive task you perform in Excel. • In this lesson, students will learn how to: • Create macros • Run a macro • Make changes to a macro • Add a macro to a button

  6. Understanding Macros • A macro records a series of steps that you do frequently, such as formatting text. • Visual Basic for Applications (or VBA) is the program used to create macros. • Coderefers to the macro actions formatted in easy-to-read sentences.

  7. Reviewing Macro Security Settings • Macros are susceptible to a virus attack. • A virusis a computer program that is designed to reproduce by copying itself and attaching to other programs in a computer. • Can cause extreme damage to data • You can set one of four macro security levels in Excel.

  8. Reviewing Macro Security Settings (continued) • Macro security level options

  9. Reviewing Macro Security Settings (continued) • Trust Center dialog box

  10. Recording a Macro • To begin recording a macro: • Click the Record Macro button in the Code group on the Developer tab. • Fill out the options in the Record Macro dialog box. • Click OK to close the dialog box; the macro will start recording.

  11. Recording a Macro (continued) • Record Macro dialog box

  12. Saving a Workbook as a Macro-Enabled Workbook • The file extension .xlsm is used for a macro-enabled workbook. • A macro-enabled workbook lets you save a macro in the workbook and run the macro. • You can save an ordinary Excel workbook as a macro-enabled workbook using the Save As command.

  13. Saving a Workbook as a Macro-Enabled Workbook (continued) • Save As dialog box

  14. Running a Macro • After a macro is created, it is ready to use. • Excel provides different ways to run a macro: • Use a shortcut key combination if one was created in the Record Macro dialog box. • On the Developer tab in the Code group, select the Macros button. • The Macro dialog box appears. • Click the macro you want and click the Run button.

  15. Editing a Macro • Macros are easy to edit. • To edit a macro, you need to make changes to the VBA code. • The code word Sub indicates the start of the macro. • The code End Sub signals the end of the macro.

  16. Editing a Macro (continued) • Example of a macro in VBA code

  17. Editing a Macro (continued) • Making edits to the Formats macro

  18. Creating a Button • A buttonis called a control. • Controls the actions that are assigned to it • When you create a button, you are asked to assign a macro to it. • When you click the button, the macro will run.

  19. Creating a Button (continued) • Worksheet with both buttons added

  20. Aligning and Formatting Buttons • To select a button with an assigned macro, right-click the button. • A shortcut menu appears. • With more than one button selected, the Format tab appears on the Ribbon. • Format tab has options to make changes to the buttons, such as aligning buttons.

  21. Aligning and Formatting Buttons (continued) • Alignment options

  22. Aligning and Formatting Buttons (continued) • You can right-click a button and choose Format Control from the shortcut menu. Format Control dialog box

  23. Opening a Macro-Enabled Workbook • When a workbook with macros is opened, a security warning appears on the Message Bar. • The warning is displayed whenever the Disable all macros with notification option is chosen. • To enable the macros, click the Enable Content button on the Message Bar.

  24. Opening a Macro-Enabled Workbook (continued) • Message Bar with security warning

  25. Summary In this lesson, you learned: • Macros can automate frequently used tasks. • You can review and change macro security settings. • You can record a macro. • A workbook can be saved as a macro-enabled workbook.

  26. Summary (continued) • After a macro is created, you can run the macro. • If changes need to be made to a macro, you can edit the macro. • Buttons are a type of form control that have a macro assigned to them.

  27. Summary (continued) • Buttons can be aligned and formatted. • When you open a macro-enabled workbook, you can enable the workbook contents and run any macros in the workbook.

More Related