Enable VBA Tools of the Developer Tab in Microsoft Office Excel 2013
VBA Tools in Microsoft Office Excel helps you to code VBA and to create Macros. In Microsoft Office 2013, Developer tab not visible for excel by default. In this article we discuss about how to enable Developer tab which contains VBA tools and use of each tool in the Microsoft Excel 2013.
To enable the Developer tab, Open Microsoft Office Excel 2013 => select File tab => select Options as shown below
Select Options in the File menu, options window displays. In Options window select “Customize Ribbon” from the left navigation. Under Customize Ribbon, select Developer tab from the right side list as shown below.
Now you can find DEVELOPER tab in the Microsoft Office 2013 Excel main menu as shown below.
Under DEVELOPER tab, you can find many icons like Visual Basic, Macro, Record Macro, Use Relative References, Macro Security, Add-Ins, COM Add-Ins, Insert, Properties, View Code, Run Dialog, Source, Import, Export, and Document Panel.
Visual Basic icon use to open the Visual Basic Editor.
Macro icon used to open Macro dialog, where you can run or edit the any macro from the list of macros.
Record Macro used for recording a macro.
Use Relative Reference icon toggles between relative or absolute recording. By using relative recording Excel can record how many cells we move down whereas with absolute recording Excel can record to which we moved.
With the help of Macro Security icon, we can allow or disallow any macro to run.
Through Add-Ins icon we can add any Add-In.
Through COM Add-Ins we can add any COM add-in.
With the help of Insert icon, we can insert any control like Button, Label, TextBox…etc on the worksheet.
With the help of Import & Export icons under XML group, we can import and export the XML documents.
The Modify group enables you to specify whether the Document Panel is always displayed for the new documents or not.
