Recording Macros
Choose Tools, Record Macro, Record New Macro to display the Record New Macro dialog box. Click the Options button to see an expanded dialog box. The script that is recorded is written in Visual Basic for Applications.
Click on the Stop Recording button to stop the recorder.
The terms script, macro and procedure are used interchangeably. The recorded macro is stored in a module. A procedure is a block of Visual Basic statements that performs a specific function.