MS Excel: Open the Visual Basic Editor in Excel 2007
Question: In Microsoft Excel 2007, how do I bring up the Visual Basic editor so that I can look at the VBA code?
Answer: To open the Visual Basic editor in Excel, open your spreadsheet.
Click on the Microsoft Office button in the top left of the Excel window and then click on the Excel Options button.
When the Excel Options window appears, click on the Popular option on the left. Select the option called "Show Developer tab in the Ribbon". Then click on the OK button.
Select the Developer tab from the toolbar at the top of the screen. Then click on the Visual Basic option in the Code group.
Now the Microsoft Visual Basic editor should appear and you can view your VBA code.