You should display the Developer tab or run in developer mode when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs.
Do the following in these Microsoft Office programs:
Word, Excel, or PowerPoint
Click the Microsoft Office Button 

, and then click Excel Options
Click Popular, and then select the Show Developer tab in the Ribbon check box.