This step by step guide will explain how to display the developer tab in the Toolbar of Excel 2007.
You need a developer tab to open the VBA editor, Macros and create Form/ActiveX Controls like buttons, check-boxes, etc.
Open Microsoft Office Excel 2007 and click on START button in the top left of your Excel window.
Now click on Excel Options button.
Check “Show Developer tab in the Ribbon” option under Popular tab in Excel Options.
As soon as you click the “Show Developer tab in the Ribbon” option, it gets automatically activated in your excel.
Now you can see the below snapshot where Developer tab is enabled.
By this way developer tab will be activated in Excel 2007.