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

teradata macro exampleif clause exceldata analyst interview questions and answers for freshersexcel macro write to text filepivot table in sql server examplevba code in excelsql workbookvba array functionsremoving duplicate data in excelexcel protect sheetproject gantt chart template excelexcel vba tablerow in vbahow to create command button in excelexcel vba chartexcel equality testapplication.enableeventsmod row excelvba coding basicswhat is the default column width in excelmerge tabs excelmatch excel formulasql ddl dml dcl tcl commands pdfdelete rows in vbaduplicate function in excelhow to protect cells in excel 2007excel trim commandexcel graph wizarddeveloper ribbon in excel 2007excel vba hyperlinkhow to remove duplicates in excel 2013microsoft office project management templatesclear cell vbaexcel unshare workbookgetting started with vbacount identical cells in exceloutlook.application vbaif iserror vbaview hidden tabs in excelusing vbavba xml tutorialvba protect sheetvb array lengthactivex tutorialinterview question answer for fresherexcel vba select rowvba examples excelchart wizard excelmacro delete rows based on cell valuevba isnahow do i unhide a row in excelexcel eliminate empty rowsexcel averageif formulahow to drop down list in excel 2007vba selection endremove duplicate records excelvba write formula to cellhow to delete repeated entries in excelmeeting minutes template microsoft wordchart types in excel 2010how to insert new worksheet in excelhow to highlight duplicates in excel 2003use of hlookup in exceluserform unload vbahow to do sumif in excelvba change cell colorexcel activeworkbook saveasexcel replace in formulaexcel vba close workbooktechnical interview questions and answers for freshers pdfvisual basic excel 2007 tutorial pdflistbox listindexexcel convert to xml formataddition in columns worksheetsexporting xml to excelvba functions excelvba selection deletewhat is a vlookup function in excelhow to use autofit in excel 2013