E1enlchi2gr-derml2h lann_care_ 13 instructions [compstibilit 1lode] word mailings revie table design tel mehat cuant toc d view laycut aabbccl aabbc aabbccl aabbccl aabbce) aabbccc aallbccd emphasis t normal t normal l.. heading 1 subtitle t title strong paragraph styles ml2 hw - lawn care 1.3 ex16_xl_ch12 grader project description: you own a smal landscaping business and have recently experienced an increase in new customers. to manage the added workload, you will create an invoice template. the template will contain macros to both finalize the document and reset to default settings. to minimize the amount of development time required, you will download and edit an existing template. instructions: for the purpose of grading the project you are required to perform the following tasks: points possible instructions step open the file exploring e12 grader h2 lawncare. xdsx and save it as a macro-enabled template named e12m2lawncare lastfirst. 0.000 1 10.000 change the template theme colors to green yellow. delete the logo placeholder located in the upper left corner and slogan placeholder located in cell c2 5.000 3 edit the placeholder text in cell b4 to reflect the company name shield lawn care and apply the title cell style. 10.000 10.000 unlock cell b19, the range b22: d30, and cell e7. 5 10.000 clear the contents of cells b19, b22: d30, e12: e16, and cell e7. 6 7.500 create a macro named finalize. the macro should insert the current date in cell e7. 7 a
re it teble design ference tlailing l cut ie: dabbccl aabbc aabbcel aabbcel aabbcel aabbccd aasbcdd a 1 title t normal normal l strong subtitle emphasis heading 1 styles ралаgraph 7.500 create a macro named finalize. the maro should insert the current date in cell e7. create a formi control button that spans the range b35: c37, assign the finalie macro, and edt the button text to finalize. 11.000 8 use the veaal barac editor to create a new module. create a new sub procedure within the module named reset. the sub procedure should clear the contents of cell e7, the ranges b19: c19, and b22: 030. 10.000 create a form control button that spans the range d35: e36, assign the reset nacro, and edit the button text to reset. 11.000 10 current instruction docx updated: 09/25/2017 excel project office 2016-mitdabcarader-instructions points possible instructions step create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each workssheet. 10.000 11 open the vba editor and display the module containing the finalize code. copy the code beginning with the text sub finalize q and ending with the first instance of the text end sub paste the contents in cell 82 of the code worksheet. 5.500 12 display the module containing the reset code, copy the code beginning with the text sub reset 0 and ending with the first instance of the text end sub. paste the contents in cell e2 of the code worksheet. close the vba editor. a
aabbccl aabbc aalbbccl aalbbccl aabbccl aabbccc aatbcne t normal l.. strang subtitle sttle heading 1 1 normal emphasis styies pasagsaph create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet. 10.000 11 open the vba editor and degplay the module containing the finalze code, copy the code beginning with the tet sub finaize qand ending with the first instance of the text end sub paste the contents in cell b2 of the code workheet, 5,500 12 display the module containing the reset code. copy the code beginning with the text sub reset oand ending with the first instance of the tedt end sub. pate the contents in cell e2 of the code worksheet. close the vba edtor. save the workbook as an excel worlbook (xkx) and dose the workbook. based on your instructor's directions, submit el2m21awncare lastfirst. adx 0.000 13 100.000 total points a