VBA: Macro tools in Excel 2007

In Office 2007 applications macro tools can be enabled by adding the Developer tab in the Office ribbon. To do this in Excel, click the office button and then click Excel Options. In the Excel Options dialog check the Show Developer tab in the Ribbon. Click OK. Now the Developer tab should appear in the ribbon. See picture 2.

The picture below illustrates checking the Show Developer tab in the Ribbon option. Click on the picture to see it in it's original size.


Picture 1. Show Developer tab in the ribbon option.

The picture below illustrates the Developer tab in the Excel ribbon. Click on the picture to see it in it's original size.


Picture 2. Developer tab.