Question: If necessary, add the Developer tab to the ribbon. Create an absolute macro on the TicketOrder worksheet that will clear the contents of all cells


If necessary, add the Developer tab to the ribbon. Create an absolute macro on the TicketOrder worksheet that will clear the contents of all cells containing data entered by the user. This includes the cell ranges B4:B6, B10:B15, and B18:B19 Select all three ranges before clearing the contents. Make cell B4 the active cell after the macro is run. Name the macro ClearData and assign the letter d as the shortcut key. 10 After creating the macro, click the Undo button to undo the change you made. Hint: To add the Developer tab, click the File tab, click Options, click Customize Ribbon, click Developer. To create a macro, on the Developer tab, in the Code group, click Record Macro. To Wii
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
