Question: Use Excel Options to show the Developer tab on the ribbon. Enable all macros in the workbook. Record a macro named Heading. Follow these steps

Use Excel Options to show the Developer tab on the ribbon. Enable all macros in the workbook. Record a macro named Heading. Follow these steps in the Friday worksheet:
* Insert three blank rows 1:3.
* Copy A1:A2 from the Wed worksheet and use Paste Using Source column widths to A1 in the Friday worksheet.
* Replace A2 text with Friday, and then stop recording.
Save the file as a macro enabled workbook using the same filename. Open the Last_First_MOS19_XL_Expert_PROJ1_Manage.xlsx file.
Copy the Module1 macro from the Last_First_MOS19__XL_Expert_PROJ1_Manage.xlsm file to the Visual Basic editor in the Last_First_MOS19_XL_ Expert_PROJ1_Manage.xlsx.
Run the Heading macro in the Excel workbook.
In VBE, delete any empty lines or lines () in the Module1 code. Copy the code and paste the code in cell A1 of the Macro sheet in the Last_First_MOS19_XL_Expert_PROJ1_Manage.xlsx workbook.
Save the workbook as a macro free workbook. Close the Visual Basic window and close the macro enabled workbook.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!