Exp19_Excel_Ch12_ML1_Sorority_Dues

profileSolutions Aplus
 (Not rated)
 (Not rated)
Chat

Exp19_Excel_Ch12_ML1_Sorority_Dues

Exp19 Excel Ch12 ML1 Sorority Dues

Excel Chapter 12 Mid-Level 1 - Sorority Dues 

  

Project Description:

You are the outgoing treasurer of your sorority and as your last task, you would like to create a membership template to enable future treasurers to track memberships, dues, and activities. To reach your goal you will download and customize an Excel template. As part of the customization process, you will create a macro to format text, use VBA to protect the workbook, and inspect the workbook for issues.

     

Start Excel. Download and open   the file named Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

 

Click cell A1, delete the   template text, and type Membership Dues.

 

Delete Column L.

 

Select the range A1:L7 and clear   all data validation that was included in the template.

 

Add a comment in cell A1 that   says "Unprotect the   worksheet before editing.". Be sure to enter the comment as it appears, including the   period and excluding the quotation marks.

 

Use the Macro Recorder to record   a macro named Sort that sorts the records in ascending order based on selection   (Hint: use relative references when recording the macro).

 

Ensure the Developer Tab is   enabled, then create a Form Control Button named Sort spanning the cell range C1:D1 (ensure that the   button is inside the cell borders), and assign the Sort macro. Be sure the   label is displayed on the Form Control Button.

 

Use the VBA Editor to insert a   new module named Unprotect. To complete the step, type the code as it appears   below. Note there is one blank line after the opening declaration (sub   Unprotect). The remaining code does not have space between lines.
 

Sub   Unprotect()
 

‘Unprotect   Sheet
Worksheets("Member   List").Unprotect.Password = "eXploring"

 

Insert a new module named Protect. To complete the step, type the   code as it appears below. Note there is one blank line after the declaration   (Sub Protect). The remaining code does not have space between lines. Type the   following to complete the procedure.
 

Sub   Protect()
 

‘Protect   Sheet
Worksheets("Member   List").protect.Password= "eXploring"

 

Exit the VBA Editor and create a   Form Control Button named Unprotect spanning the cell B1. Assign the   UnprotectWorksheet macro. Be sure the label Unprotect appears on the Form control   button. Then save the file as a macro enabled workbook.

 

Create a Form Control Button   named Protect spanning the cell E1. Be sure   to display the label Protect on the Form Control Button and then assign the Protect macro.

 

Use the Document Inspector to   check the document for issues. Remove the Document Properties and Personal   Information and the Headers and Footers information. Do not remove Comments   and Macro information. Note: If using a Mac, please skip this step and   proceed to step 13.

 

Check the document for   Accessibility and compatibility with Excel 2010, 2013, and 2016.

 

Insert a new worksheet named Code.

 

Open the VBA Editor, open module   1, and copy the code. Paste the code in the Code worksheet starting in cell   A1. Then delete the rows that are blank (2,4,5, and 6).

 

Open the VBA Editor, open the   Protect module, and copy the code. Paste the code in the Code worksheet   starting in cell A17. Delete any additional blank rows that appear in the   code (row 18).

 

Open the VBA Editor, open the   Unprotect module, and copy the code. Paste the code in the Code worksheet   starting in cell A22. Then delete any additional blank rows that appear in   the code (row 23).

 

Save and close Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx.   Be sure to save the workbook as a .xlsx   file, not a macro enabled workbook. Exit Excel. Submit the file as directed.

  • a year ago
Exp19_Excel_Ch12_ML1_Sorority_Dues
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    Ahmed_EXP19_Excel_Ch12_ML1_HW_MembershipDuess.xlsx