Challenge Project 8-9

In this project, you add two macros to the Blue Lake Sporting Goods invoice form. You record a macro to copy the sheet and assign it to a Button control. You record another macro to delete data on the copied sheet. Finally, you print your macro code.

[Student Learning Outcomes 8.1, 8.2, 8.4, 8.5]

File Needed: Challenge-08.xlsm (Student data files are available in the Library of your SIMnet account.)

Completed Project File Name: [your initials] Excel 8-9.xlsm

Open the Challenge-08 macro-enabled workbook from your student data files. Save it as a macro-enabled workbook named [your initials] Excel 8-9. Modify your workbook according to the following guidelines:

• Write a macro to copy the Vendor Order worksheet at the end of the tabs. Assign the macro to a Button form control below the existing controls on the original Vendor Order sheet.
• On the copied sheet, write a macro to delete the contents of cells with data. Include the PO #, the date, the vendor information, department name, and item data. Be sure to include all item description lines that might have data. Although you can deselect the Yes box, it Is not recorded as macro code.
• Delete the copied sheet. Copy the Vendor Order sheet again and test your macro to delete the data. Delete the copied sheet.
• Add a Button form control on the Vendor Order sheet below the existing controls and assign the macro that copies the worksheet.
• Align and size all the controls to be uniform.
• Open the Visual Basic Editor and the Code window for Module 1 to print the code. If your macros are in separate modules, open Module 2 and print the code.