1. Navigate to your Excel Chapter 9 folder, and then double-click the Excel file you downloaded from MyLab IT that displays your name—Perez_Excel_9E_Operations.xlsx. Verify that the Developer tab is enabled and the Macro Settings are set to Disable all macros with notification. Display the Save As dialog box, navigate to your Excel Chapter 9 folder, set the Save as type to Excel Macro-Enabled Workbook, and then save your file.
2. With cell A1 active, record a macro with the name Operations_Header and the shortcut key Ctrl + m. (Mac users, use Option + Command + m.) Store the macro in This Workbook. As the description, type Fills in Operations report heading and then click OK to begin recording the macro.
3. Insert two blank rows at the top of the worksheet, and then click cell A1. Type WPHRC Operations Department and then Merge & Center the text you typed across the range A1:E1. Apply the Title cell style. In cell A2, type Quarterly Report and then Merge & Center the text you typed across the range A2:E2. Apply the Heading 1 cell style. Center the worksheet Horizontally, click cell A1, and then stop recording the macro.
4. Delete rows 1:2, click cell A1, and then test the macro.
5. On the Developer tab, in the Code group, click Macros. Verify that the Operations_Header macro is selected, and then click Edit. Scroll down and locate the first instance of End With, and then in the fourth line following End With, edit Quarterly Report to indicate Quarterly Operations Report.
6.Click File, and then click Close and Return to Microsoft Excel. Delete rows 1:2, click cell A1, and then use the keyboard shortcut to run the macro to test that Quarterly Operations Report displays as the subtitle of the report.
7.Insert a footer with the file name in the left section, and then display the worksheet in Print Preview to verify that the worksheet is centered horizontally. Display the file properties. As the Tags, type operations department report and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author. Save your workbook.
8.On the Developer tab, in the Code group, click Macros. Select your Operations_Header macro, and then click Edit. Select and Copy all of the code. Close and Return to Microsoft Excel. In the sheet tab area, click New sheet to insert a new worksheet. Rename the inserted sheet Macro Code and then with cell A1 active, Paste the code to the new worksheet. AutoFit column A.
9. Click the File tab, and then click Save As. Navigate to your Excel Chapter 9 folder, and then click the Save as type arrow. Click Excel workbook. In the File name box, type Student_Excel_9E_Operations_VBA and then click Save. In the displayed message box, click Yes. Close your file and submit your Student_Excel_9E_Operations_VBA file as directed.
Our Advantages
Plagiarism Free Papers
We ensure that all our papers are written from scratch. We deliver original plagiarism-free work. To guarantee this, we submit all work alongside a plagiarism report.
Free Revisions
All our papers are completed and submitted before the deadline. We ensure this to provide you with enough time to go through the work and point out any sections or topics that may need revision or polishing. We provide unlimited revision services for free.
Title-page
All papers have a title page providing your personal and institutional information. We do not charge you for this title page.
Bibliography
All papers have a bibliography or references page. This page is a requirement for academic and professional documents. We provide this page at no cost for all our papers.
Originality & Security
At Thehomeworklabs, we guarantee the confidentiality and security of your information. We value our clients and take confidentiality seriously. All personal information is treated with confidentiality and stored safely to ensure that no third parties gain access to it. We also provide original work and attach an originality/plagiarism report alongside all papers.
24/7 Customer Support
Our customer support team is available 24/7 to provide you with any necessary assistance when you need it. You can contact us at any time, day or night, via email or through the live chat button.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
We provide our customers with the best experience in the academic and business writing field.
Pricing
We provide the best quality of service at affordable prices. We also allow our clients to make partial payments for their orders. You can also contact our customer support team in case you need to discuss a different payment plan.
Communication
Admission help & Client-Writer Contact
We realize that sometimes clarification is necessary to ensure that quality work is done. Therefore, we provide a button for clients and writers to communicate in case some clarification is needed.
Deadlines
Paper Submission
We ensure that we submit all papers ahead of their respective deadlines. This allows you to go through the documents and request any revision, corrections, or polishing before the paper is due.
Reviews
Customer Feedback
We encourage customer feedback, positive or negative. We can identify the various areas that we need to improve to provide even better services through your feedback. Please feel free to give us feedback.