When you click the "Insert" button, a dropdown displays all of the available components that you can add to your spreadsheets. With a button, you can trigger an event and use it to perform an action.Ĭomponents for VBA actions are found in the "Developer" tab in the "Insert" button dropdown. When you want to use VBA on your spreadsheet, buttons are one of the most common elements that you add to your document. Click this tab, and you'll see the VBA button available on the left side. You should now see an additional tab marked "Developer" in the list of Excel 2019 menu options.
Click "OK" to enable the tab and return to your Excel 2019 interface. This check box enables the "Developer" tab in your Excel view.
In the image above, notice that the developer option is checked in the far right panel. Click the "Customize Ribbon" option in the left panel. This opens a new configuration window where you can set preference for different elements of Excel. If you don't have the "Developer" tab enabled, follow these next steps to enable it.Ĭlick the "File" ribbon tab, and then click the "Options" link that shows in the bottom-left section of the Excel window. The "Developer" tab has several buttons and features that enhance the way you create spreadsheets. To use VBA, you need the "Developer" tab enabled.
VBA can get complicated, but knowing how to create basic code and functionality can improve your spreadsheet's usefulness and automate certain activity that would take hours of time. You can create add-on components within your basic Excel 2019 spreadsheet to create additional functionality. Now, you can see that the Developer Tab is disabled from the Ribbon.Visual Basic for Applications (VBA) is a form of the Visual Basic programming language integrated into all Microsoft Office products. Under the Main tabs on the right, Untick the Developer Tab, and click on the OK button at the bottom of the screen, as shown in the screenshot below. Step 3: A Customize Ribbon dialog box appears with the selected Customize Ribbon option on the left. A small dialog box pop up, in which click on the Customize the Ribbon option. Step 2: Right-click anywhere on the Ribbon. Step 1: Open the new or an existing Microsoft Excel document. Disable the Developer TabĪfter enabling the Developer Tab, you can also disable it using the below mention easiest steps. Note: Enabling the Developer Tab is a one-time process, now the Developer Tab will automatically appear on the Ribbon whenever we open a new Microsoft Excel document. Now, you can see that the Developer Tab has been added to the Microsoft Excel Ribbon. Tick on the Developer check box under the Main Tabs and then click on the OK button at the bottom of the Customize Ribbon dialog box, as shown in the screenshot below. Step 4: Customized Ribbon options appear on the right side of the screen. Note: You can also open the Customized Ribbon dialog box by right-clicking anywhere on the Ribbon and select the Customize the Ribbon option. Click the Customize Ribbon option from the left pane. Step 3: An Excel Options dialog box will appear on the screen.
A list of File options will appear on the screen. Step 2: Click on the File option in the upper-left corner of the document. Step 1: Open a new or existing Microsoft Excel document.
There are the following steps to enable the Developers Tab in Excel - Note: The below steps help you to enable the Developer Tab in Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office365. When you enable the Developer Tab, it will automatically appear in the Excel document followed by the View tab. Note: By default, the Developer Tab is not displayed on the Ribbon. It also allows us to import and export XML files, manage XML maps, use XML commands, and more. Next → ← prev How to enable the Developer Tab in Excelĭeveloper Tab is an in-built tab in the Excel document that allows us to access various commonly used features to create Macros, Visual Basic for Applications (VBA), Controls (Insert ActiveX and Form controls), as well as Add-ins.