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 :
Copy A:A from the Wed worksheet and use Paste Using Source column widths to A in the Friday worksheet.
Replace A text with Friday, and then stop recording.
Save the file as a macro enabled workbook using the same filename. Open the LastFirstMOSXLExpertPROJManage.xlsx file.
Copy the Module macro from the LastFirstMOSXLExpertPROJManage.xlsm file to the Visual Basic editor in the LastFirstMOSXL ExpertPROJManage.xlsx
Run the Heading macro in the Excel workbook.
In VBE, delete any empty lines or lines in the Module code. Copy the code and paste the code in cell A of the Macro sheet in the LastFirstMOSXLExpertPROJManage.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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
