- Click the Microsoft Office Button, and then click Excel Options
- Click Popular, and then select the Show Developer tab in the Ribbon check box.
Programming with VBA in Excel allows for spreadsheet manipulation that may be awkward or even impossible with standard spreadsheet techniques. This may be accomplished by writting code directly in the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization. To find out how to access the VBE by adding the developer toolbar to your excel 2007, 2010 and 2013 versions of Excel, please follow the appropriate link in the Related Articles section.Read More