Introducing the Visual Basic Editor
When you clicked OK in the Record Macro dialog box, Excel created a container, called a module, for the new VBA code, storing the module in the active workbook. As you carried out the actions for the recorder to record, Excel transcribed those actions into the new module.
The module doesn’t appear with the other worksheets and chart sheets in the workbook. To view it, click Visual Basic in the Code group on the Developer tab. This takes you to the Visual Basic Editor. In the upper-left corner of the Visual Basic Editor, you’ll find a small window known as the Project Explorer:
Yours will look different depending ...
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
