![how to enable disable macros in excel 2010 how to enable disable macros in excel 2010](https://i.ytimg.com/vi/ZLQ_X_Vxyx0/maxresdefault.jpg)
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.
![how to enable disable macros in excel 2010 how to enable disable macros in excel 2010](https://cdn.extendoffice.com/images/stories/doc-outlook/save-attachments/doc-save-attachments-4.png)
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.
![how to enable disable macros in excel 2010 how to enable disable macros in excel 2010](https://i.ytimg.com/vi/9LiIpLIOyLo/maxresdefault.jpg)
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. Macros enable you to automate almost any task that you can undertake in Excel 2010. It also allows us to import and export XML files, manage XML maps, use XML commands, and more.
#How to enable disable macros in excel 2010 how to
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.