tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Open the Visual Basic Editor in Excel 2007

See solution in other versions of Excel:

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