Click the Developer tab in your Excel window. Then below menu will appear under Developer tab:
Image 1: Developer tab
In this image you will see Add-Ins and Document Panel Modify options, which is added from Excel 213. In the previous versions of Excel these 2 options are not available. Let's see what can we do with these options of Developer tab step by step.
Code Group:
In the code group total 5 options are available.
Image 2: Code group
Visual Basic icon will help us to show the VB Environment in Excel where you can write codes, whose short cut is ALT+F11. Another shortcut is ALT+L+V.
Macro option will display a list of macros you have written or recorded if you click on it. You can Run, Edit, Create, Delete your macros from this dialog box.
Record Macro is for recording a new macro. After clicking on this button this will change to Stop Recording Macro.
Use Relative References is for using the macro for dynamic cells. As we know that, Excel VBA always works for absolute (example $A$3) reference, but Relative Reference (example A3) option will help you to show your macro result where your cursor placed. After clicking the Record Macro click this Use Relative References option to activate while recording your macro.
Macro Security is for changing the security settings of macros. You can enable or disable macros with or without notification.
Add-Ins Group
There are only 2 options in this group:
Image 3: Add-Ins group
Add-Ins are 2 types in Excel. The first one is Automation Add-Ins. Add-Ins tool will help you to show a list of Add-ins created by you. If you save any excel document as Add-Ins then it will show here. You can run it by selecting the check box. This type of Add-Ins are called Automation Add-Ins. Once you create an Add-Ins You can use this in all workbooks. But the problem is the source code will show in VBE.
The COM Add-Ins means Component Object Model (COM). This type of Add-Ins are professional. These are developed in VB and a .dll file helps to run it on all workbooks without showing the source codes. When a COM Add-in is installed, registry entries are created for the Add-in. COM Add-ins used by Excel are registered in the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\
Control Group:
Again there are 5 options in Control group.
Image 4: Control group
Insert option will allow you to insert the control buttons, forms to design your own applications.
Image 5: Insert controls
Design Mode will allow you to edit the design of your VB Application. You can work with Form Controls and ActiveX Controls in Design Mode.
Properties option is to display the properties of a specific object you have selected. You can change the caption, background color or others settings of an object.
Clicking on View Code you will be able to view the macro codes written in VB Environment. Please don't think that, you cannot allow to edit macro codes in this window. Yes You Can.
Run Dialog will display a list of custom dialog box or forms, which you have created in VB Environment.
XML Group
Excel can works with XML data. You can create XML file from Excel or create Excel file from XML. There are 6 options are available in this group.
Image 6: XML Group
Source option will allow you to collect the source file you want to convert.
Map Properties will help you to select the fields or columns which you want to convert.
Expansion Packs is the group of files that constitutes a smart document. This tool lets users to attach, delete, create or edit an XML Expansion Pack.
Refresh data is used to refresh XML connection and data displaying.
Import is used to convert the data from XML to Excel
Export is used to convert the data from Excel to XML.
Modify Group:
In the modify group there is only one option available.
Image 7: Modify Group
Document Panel is used to add the custom information of a document which saved in Microsoft InfoPath. You can view the Excel document info from Home | Info | Properties | Show Document Panel or Advance Properties.