Question: To answer this question, complete the lab using the information below. You will only be allowed one attempt to complete this lab. You are an
To answer this question, complete the lab using the information below. You will only be allowed one attempt to complete this lab.
You are an accountant for a large accounting firm. You have been tasked with creating worksheets with date-sensitive information. To save time, you want to create a macro that automatically inserts a row with the date for version control. Perform the following actions:
- Enable the content in the current workbook.
- Customize the ribbon to add the Developer tab for creating and editing macros.
- Record a simple macro named InsertDateRow that does the following:
- Inserts a new row at the top of the active worksheet
- Uses the TODAY() function to add the current date in cell A1
- Insert a new worksheet named Data2.
- Run the newly created InsertDateRow macro on the Data2 worksheet.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
