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 excel tableexcel vba gotoexcel 2010 unprotect sheetexcel if isnahow to insert blank lines in excelworkbooks open filename errorvlookup tutorial excelvba programming basicssorting in excel 2007adding developer tab in excel 2007paste in vbatricky interview questions and answers for freshersremove macro excelhow do i insert a checkbox in excelvba excel passwordhow to label columns in excelstatic array in vbremove blanks in excelremove duplicates from excel spreadsheetcool excel chartsvba vbokcancelexcel check boxsimple macros in excelvb6 interview questionsestimating spreadsheet templateexcel vba codevba for excel tutorialdelete filtered rows in excelexcel 2007 drop down listcool vb projectsusing macros in excel 2007spss sqlvba unlock workbookworkbooks vbavba protect workbookvlookup function in excel examplemacro remove duplicatesexcel graph filterexcel command to insert rowpassword protecting an excel spreadsheetembedded chart in excelhow to set column width in excelexcel chart titlemacros in excel 2007 for beginnersexcel macro file extensionhow to collect data from multiple excel fileswhat are the ddl commandsvba combobox multiple selectionmerge 2 columns in excelexcel vba pivot table filterhow to unprotect excel sheet without password freepaste vba excelsumif examplems excel operatorsexcel formula change cell colormatch function in vbavba sort excelvba lower casevba application.waitddl dml dcl tcl commands sql serveradvanced excel pptexcel worksheet tabwhile loop vbaadodb connection openvba range copymacro in excel 2010 with examplemicrosoft excel offsetautomatic row height excelms access iserrorexcel sum ifyes no message box vbavba lastrowexcel macro delete blank rows