If necessary, add the Developer tab to the ribbon. Create an absolute macro on the TicketOrder worksheet named ClearData with the capital letter D as the shortcut key that will clear the contents of all cells containing data entered by the user. This includes the cell ranges B$4$:B$6,$ B$10$:B$15,$ and B$18$:B$19.$ Select all three ranges in the order given before clearing the contents. Make cell B$4$ the active cell after the macro is run.

After creating the macro, click or press the Undo button to undo the change you made.

Add a form control button and assign the ClearData macro to the button. Change the button caption to Clear Data. Test the button.

On the Developer tab, in the Code group, click or press Macros, and then select Edit. Copy the macro code and close the Microsoft Visual Basic for Applications window. Display the Macro worksheet and paste the copied macro code in cell A$1($there should be $11$ lines altogether$).$

On the TicketOrder worksheet, unlock cells A$17,$ B$4$:B$6,$ B$10$:B$15,$ and B$18$:B$19.$

From the Format Cells dialog box, hide all cells that have formulas: B$7,$ B$20,$ and B$21.$

Hide the horizontal and vertical scroll bars. Note, Mac users can skip hiding the scroll bars.

Hide the row and column headers.

Hide the gridlines. Protect the worksheet.

Save the workbook as a macro$-$free workbook. Mark the workbook as final $($Mac users, apply the Always Open Read$-$Only option$).$