Hide Developer Tab in Excel Ribbon

Home/VBA/Hide Developer Tab in Excel Ribbon

Hide Developer Tab in Excel Ribbon using from the Excel options. It helps to prevent users from opening the Excel VBA editor window.


Hide Developer Tab in Excel Ribbon:

  • Right click on any main menu item in the Ribbon. Please find the below screen shot for the same.
  • Excel VBA Develoer Tab

  • Click on Customize the Ribbon…, this will show you Excel options window.
  • Now uncheck the developer Tab from the Main Tabs list in the excel options window (Right Side). Please find the below screen shot for the same which is highlighted in yellow color.
  • Excel Options VBA Develoer Tab

  • Click on ok button.
  • Step 5: Now you cannot see the ‘Developer Tab’ in the Excel Ribbon and prevent user to go to Excel VBA editor window.

    Related articles:

    Here the following link to enable or show developr tab in Excel ribbon.
    Show Developer Tab

    Here the following link to record macro in Excel VBA.
    Record a Macro

By |October 8th, 2016|VBA|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment