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.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

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.
  • 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.
  • 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

Related pages

vba combobox rowsourcevba excel open text filehow to use sumif in excel 2013project manager excel templateproject charter sample templatesumif function exampledata dashboard templatebeginner vbaexcel workbook vbaunhide all rowssql server macroexport from excel to access vbahow to combine columns in excel 2007excel 2007 autofit row heightvba create querytransfer spreadsheet vbavlookup function with examplesql equality operatorsfilter in vbasoftware development estimation templatepivottables in excelgreater than formula excelcopy sheet excel vbavba reference sheet by namepurge excel filevba change font sizevba adodb connection referencems excel countifssql tutorial for beginners with examples pptcreating pivot table in excel 2007vba copy fileslogical operations in excelconnect to sql server from excel vbaworksheet copy vbadata entry form in excel 2007how to hide columns in excel 2007unprotect workbook excel 2013excel vba lastrowvba variant arrayexcel infographic dashboardexcel hidden columnexcel remove macrocol index num in vlookupexcel vba divisiondim conn as adodb connectionexcel sheet hiddenvba show userforminterview questions and answers in c programming language pdfadodb.connection connection stringremoving duplicates in excel 2003ms excel test questions and answersinterior.color vbaexport excel to access vbaunprotected excelhow to sort a column alphabetically in excelproject management templates excelexcel vba booleanpivot table tutorial 2013free excel dashboards templatesplotting charts in excelcreate a pivot chart in excel 2010vba getrowsexcel activex controlsvba code libraryremove duplicates from excel listexcel vba best practiceslistbox codeapplication defined error vbaadd the developer tab to the ribbon wordssis check if file existsadodb recordset in vbaformula offset excelexcel 2007 iferrorvlookup excel functionaccess vba programming examplesvba close userformapplication worksheetfunctionlook up formula excelshortcut key to show formulas in excelcheck excel for duplicateshow to use vlookup function in excel 2010interactive excel dashboard