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.
Now check the Developer option in the right sidebar and hit OK.
That’s it, you will find the Developer tab on the Ribbon.
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.
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.
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.
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.
Modify
The Modify section contains the Document Panel option only.
4 Comments
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Thanks a lot as shown in above Print Screen Pictures, I could add the developer tab Successfully.
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.
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.
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.