Description
Excel comes with Visual Basic for Application (VBA) development environment. VBA is very handy to create custom code for Excel. However, standard 2010 Excel installation hides the development tab the ribbon as shown below.
Steps to show Development Tab in Ribbon
- Go to File -> Option -> Customize Ribbon and click on it.
- Check “Developer” box
Enable Excel Developer Tab in Ribbon - Now, you can access Visual Basic editor with easy.
Excel Developer Tab in Ribbon