Unprotect the worksheet and create a macro button in the range $H17$:$H19$ to run the Lookup$\_$Applicants macro. Change the label of the button to Retrieve Records. Protect the worksheet again, allowing users to only select locked and unlocked cells. Do not specify a password.

Use VBA to modify the code so the application displays a message indicating the number of records found using the advanced filter. In the Visual Basic for Applications editor, directly before the End Sub statement in the Lookup$\_$Applicants sub procedure, add the following commands:

recNum $=$ Application. WorksheetFunction. Count$($Range $("$K:K$"))$

MsgBox recNum & $"$ record$($s$)$ found"

Close the editor and return to the workbook.

Choose Website Designer from the slicer to display a funnel chart of the application history for the Website Designer position.

Select Website Designer and Onsite Interview from cells F$19$ and G$19,$ and then click the Retrieve Records button to retrieve the $24$ records of applicants who got only as far as the onsite interview stage.

Save the workbook, athd then close it$.$