Open the BoydAir-08 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Set macro security and display the Developer tab.
Click the Options command [File tab] and click Trust Center in the left pane.
Click the Trust Center Settings button and click Macro Settings in the left pane.
Verify or select Disable all macros with notification and click OK.
Click Customize Ribbon in the left pane, display the Developer tab, and close Excel Options.
Open the BoydAirMacros-08 file downloaded from the Resources link. This file is an Excel macro-enabled workbook (Figure 8-37). Click the Enable Content button.
Return to the your.name.BoydAir-08 workbook opened at the beginning of the project.
Run and edit a macro to insert today’s date.
Press Ctrl+Shift+D to run the InsertDate macro. Today’s date displays in cell E1.
Delete the contents of cell E1 and press Ctrl+Home.
Click the Macros button [Developer tab, Code group].
Verify that the 'BoydAirMacros-08.xlsm'!InsertDate macro name is selected and click Edit to open the Visual Basic Editor (VBE) window. (If the Code window is not displayed, select Module1 in the Project Explorer pane and then choose Code from the View menu.)
Click between the “H” and the “1” in the second comment line and type 3 so that the address is H31 as the cell reference.