Microsoft Excel 2010 Developer Tab

Microsoft Excel is one of the most powerful applications within the Office suite. It also lets you add some programmatic power to it, you can use your programming skills to automate tasks in Excel. Two examples of this scenario are VBA and Macros. Microsoft Office 2007 and 2010 include the ‘Developer’ tab which lets you add code chunks to your Excel sheet, also it is a great way to access various Options.

How To Enable The Developer Tab?

The Developers tab is disabled by default, to enable it click the Office button and then choose Options.

Options Excel The Excel Options dialogue box will be displayed, click the Customize Ribbon option.

Customize Ribbon

Now check the Developer option in the right sidebar and hit OK.

Excel Deverloper Tab

That’s it, you will find the Developer tab on the Ribbon.

Developer Tab

A Bird’s Eye View Of The Developer Tab’s Options

The Developer tab contains different useful options for developers. All of the available options of the developer tab are categorized into the following five:

  • Code
  • Add-In
  • Controls
  • XML
  • Modify

Code

The Code section contains different options. The Visual Basic option lets you launch the Visual Basic Editor, Macros launches the list of all the created/recorded Macros, Record Macro lets you create a new Macro. The Macro Security options lets you play with the security aspects of the Macro.


Code Developer tab

Add-In

The Add-Ins option lets you enable Excel’s Add-Ins like the Solver, COM Add-Ins options enables the COM add-in which is useful for developers as it aids in writing common object models.

Add-In

Controls

It includes functionality to add the user-interface controls like ActiveX controls to your Excel spreadsheet. You can move between Code and Design Mode, and can play with the Control’s Properties and run Dialog.

Control

XML

The XML portion contains useful options for XML coding in Excel. It provides options to write XML source code, Import and Export XML files, Map and refresh your XML data.

XML

Modify

The Modify section contains the Document Panel option only.

Document Panel

Advertisement
  • word2010

    Just a heads up about some idiot who has stolen your content here: http://khmer4study.blogspot.com/2009/12/microso

    He also stole some of mine. It looks like his site is full of copied content. If you send a DMCA to Blogger, they should take this post down, as they did with mine.

    Good luck.

  • word2010

    Just a heads up about some idiot who has stolen your content here: http://khmer4study.blogspot.com/2009/12/microso

    He also stole some of mine. It looks like his site is full of copied content. If you send a DMCA to Blogger, they should take this post down, as they did with mine.

    Good luck.

  • word2010

    Just a heads up about some idiot who has stolen your content here: http://khmer4study.blogspot.com/2009/12/microso

    He also stole some of mine. It looks like his site is full of copied content. If you send a DMCA to Blogger, they should take this post down, as they did with mine.

    Good luck.

  • Dhanunjay

    Thanks a lot as shown in above Print Screen Pictures, I could add the developer tab Successfully.