Running a Macro $($Skill $10\mathrm{.}4)$

Adding a Macro to a Form Button Control $($Skill $10\mathrm{.}8)$

Open the start file EX$2021-$Fixlt$-10-6$ and resave the file as: $($your initials$)$ EX$-$Fixlt$-106.$

If the workbook opens in rotected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it$.$

Display the Developer tab. $($If you already have the Developer tab enabled, skip to step $4.)$

The workbook contains a macro named Scholarships to calculate the number of scholarships in the table named ScholarshipSummary. The keyboard shortcut is Ctrl$+$Shift$+$S$.$ If you run the macro, you'll find there is an error. Fix the error, and then run the corrected macro.

a$.$ When you try to run the macro, a message box should appear telling you that there is an application$-$defined or object$-$defined error. This means there is a problem with the macro code. Click the Debug button to open the Visual Basic Editor with the first line containing an error highlighted. Fix the error. Hint. The table name is incorrect in the highlighted line of code $($the tenth line$).$ The table name is ScholarshipSummary not Table$1.$

b$.$ Save your changes, and then close the VBE window. A message will appear telling you that closing the VBE window will stop the debugger. Click OK$.$

c$.$ Run the modified macro to test your work and continue debugging the macro until all the table name errors have been fixed.

The macro does not include a calculation to find the number of education majors $($cell D$24).$ Edit the VBA code for the Scholarships macro subroutine procedure to include this calculation.