Microsoft Excel VBA : How to enable developer tab in Excel 2007?


Sometimes we may think, from where we can enable the so called VBA and options to record macros in Microsoft Excel. Because it is in this pane we have the Visual Basic editor and other options to record macro and so on. In Microsoft Excel 2007, follow these simple steps to enable 'Developer' tab, to see the option related to Macros and VBA.


1. Click the 'Office Button'

2. Click 'Excel Options'


3.In the tab 'Popular', tick in the box (third box) 'Show Developer tab in the Ribbon' and click 'Ok'



1, 2, 3 - Tada .. You are done. Now you can see the options of VBA and Macros under the 'Developer' tab.

Stay tuned for more.

Comments