Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

E XERCISE

R ECORDING M ACROS



T ASK Record Macros.

1. Open EXER82.XLSM and enable the macros. 2. Display the Last Year worksheet, if necessary. 3. In cell A1, begin recording a macro named Today . Assign [Ctrl+m] as a shortcut key. Store the macro in the current workbook. 4. Using relative references, perform the following steps to record the Today macro: 5. Add bold and a red font color to the active cell. 6. Change the font size to 12 . 7. Type =today() . 8. Press [Enter] . 9. Stop recording the macro. Clear all contents and formatting from cell A1. ( Hint : Use the Clear button in the Editing group on the Home tab.) 10. Select cell A4 and run the macro. 11. View the macro in the Visual Basic editor; display Module3 , if necessary. Then, close and return to Excel. 12. Display the Projections worksheet. Use the shortcut key to run the macro in cell A1. 13. Delete the Today macro. 14. Deselect the Use Relative References button and close the workbook without saving it.

Page 40

OFFICEPRO, Inc.