Challenge Project 8-8

In this project, you create a macros-only workbook for an automobile manufacturer. You record macros to enter the main label and another to insert formatted lines for data entry. In a separate workbook, you run the macros and use the built-in data form to add records.

[Student Learning Outcomes 8.1, 8.2, 8.3, 8.7, 8.8]

File Needed: None

Completed Project File Names: [your initials] Excel 8-8Macros.xlsm and [your initials] Excel 8-8.xlsx

Create and save a macro-enabled workbook named [your initials] Excel 8-8Macros. Modify your workbook according to the following guidelines:

• Record a macro with absolute references and a keyboard shortcut to display main labels in cells A1:A3. The labels are American Motors Recall List, North American Unit, and recallnow@amotors.com. Format the three cells with an 18 pt. font size in the macro.
• In cell F1, type the name of your macro as documentation. In cell F2, type its keyboard shortcut.
• Select cell A5. Record a macro with relative references and a keyboard shortcut to create the data entry area. In cells A5:C5, type Year, Model, and Recall Number. Format the labels as bold and centered as part of the macro. Continue recording, select cells A5:C25, and apply All Borders. Set the width of columns B:C at 18 and stop recording.
• Add documentation in cells F5:F6.
• Insert a blank sheet and test your macros. Make edits to correct errors or delete the macro and re-record it.
• Save the macros-only workbook and leave it open.
• Create a new workbook and name it [your initials] Excel 8-8. It is a regular Excel workbook, not macro-enabled.
• Run the macro for the main labels. Select cell A6 and run the macro for the entry lines.
• Display the Form button on the Quick Access toolbar.
• Select cell A6 and click the Form button. Respond to the message box to open a blank entry form.
• Enter three records using the data entry form. After you complete the first record, press Enter to open a new blank form. Use fictitious data of your choice.
• Save and close the Excel workbook.
• Save and close the macro-enabled workbook.