Boyd Air uses a macros-only workbook and a related template. You edit and record macros In the macros-only workbook. In the template, you record a macro and assign it to a Button form control. [Student Learning Outcomes 8.1. 8.2. 8 3. 8 4. 8.5. 8 6. 8.7)
Files Needed BoydAlr-08.xlsx and BoydAlrMacros-08.xlsm (Student data files are available in the Library of your SIMnet account.)
Completed Project File Names [your Initials] Excel 8-1Macros.xlsm.
[your initials] Excel 81Template.xlsm. and [your Initials] Excel 8-1.xlsx
Skills Covered in This Project
· Set macro security options
· Use a macros-only workbook
· Edit a macro in the Visual Basic Editor
· Record macros.
Run macros.
Record a macro with relative references. Save a macro-enabled template.
Assign macros to Button form controls.
1. Set macro security and display the Developer tab
a. Click the Options command [File tabj and click Trust Center’s^ he left pane.
b Click tho Trust Center Settings button and click Macro Settings n the left pane c Verify or select Disable all macros with notification and click OK
d. Click Customize Ribbon In the left pane, display the Developer tab. and close Excel Options.
2 Open the BoydAirMacros-08.xlsm workbook from your student data flies, a macros-only workbook (Figure 8-37) Enable the macros if the message bar displays
3. Save the workbook as a macro-
enabled workbook.
a. Choose Save As from the File tab
b. Tvoe I vour initial» I Excel 8-1 Macro»
<^!
i Bovd Air Macros
