Please help! I$\text{'}$m on Mac so things look a little different!

FIGURE EX $10\mathrm{.}34$

b$.$ Fix the error. Hint: The table name is incorrect in the highlighted line of code $($the tenth line$).$ The table

name is ScholarshipData not Table$1.$

c$.$ 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$.$

d$.$ 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.

a$.$ Copy the two lines of code that calculate the number of law majors and then change the code to select

cell D$24$ and count the number of cells with the word Education.

b$.$ Run the Scholarships macro again. This time it should calculate values for cells D$21$:D$24.$ If you

encounter an error, run the debugger again and find and fix your error.

The form button to run the Scholarships macro should display the label text Count All Scholarships. Edit

the button text.

Save the workbook.

If you are going to submit this project in SIMnet, save a copy of it as a regular Excel workbook $($without

macros$).$

Close the workbook.Open the start file EX$2019-$Fixlt$-10-6.$

If the workbook opens in Protected 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 ScholarshipData. 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.