The previous section described the general steps for recording a macro. This section shows you a step-by-step example of recording a short macro that we'll open and edit in the Visual Basic Editor later in the chapter.
The macro simply copies the active worksheet to an archive workbook so that you have a reference copy of the worksheet. To copy the worksheet, the macro takes five actions:
To record the example macro, follow these steps: