Share this page:

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 Microsoft Excel in the top left of the Excel window and then click on the Excel Options button.

Microsoft Excel

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.

Microsoft Excel

Select the Developer tab from the toolbar at the top of the screen. Then click on the Visual Basic option in the Code group.

Microsoft Excel

Now the Microsoft Visual Basic editor should appear and you can view your VBA code.

Microsoft Excel