Sunday, 8 September 2013

VBA- Enable Developer Tab - EXCEL

                     Enable Developer Tab

Following are the steps to enable developer tab in Excel 2007

  • Click on 'Office Button' to top left of the workbook and then click on 'Excel Options'

  • Check the option 'Show developer tab in the ribbon' and click on OK

You might now be able to see developer tab in the workbook

  • To start the Visual Basic Editor click on 'Developer' Tab and click on the 'Visual Studio' option (very first option from left hand side)

You will now see visual basic editor to begin coding

No comments:

Post a Comment