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.

OptionsExcel thumb Microsoft Excel 2010 Developer TabView in gallery The Excel Options dialogue box will be displayed, click the Customize Ribbon option.

CustomizeRibbon thumb Microsoft Excel 2010 Developer TabView in gallery

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

Excel Deverloper TabView in gallery

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

Developer TabView in gallery

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 tabView in gallery

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-InView in gallery

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.

ControlView in gallery

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.

XMLView in gallery

Modify

The Modify section contains the Document Panel option only.

Document PanelView in gallery

  • 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.