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

dml exampleusing countif function in excelexcel macro codingms access vba export to excelhow to remove blank rows in excel 2007excel vba programming bookshow do i unhide rows in excel 2010access vba runsqlhow to add command button in excellock excel worksheetrun a macro in excelvba string manipulationvba array stringspider web diagram excelmeeting minutes template word 2010unhide column a in excel 2010vlookup vba examplelength of array vbaif iserror vbaexcel vlookup formulas with examplesddl and dml commands in sqlcombine worksheets into one worksheetformula for hlookupmacro open excel fileautofilter in excel 2007vb source code examplesexcel vba copy sheet to endexcel formula offsetcreating dashboards in excelnested if then statements in exceloperand operatordeveloper mode excel 2010is not blank excelisblank excelexcel vba variableslearn vba from scratchunprotect vbavlookup functionsexcel vba inputcommand button in exceldynamic chart excelautofit row heightexcel current worksheetexcel vba file existsend xlupexcel password protect vbainsert column excelformula concatenateword vba userformunprotect excel sheet 2007unshare excel workbookvba matrixunmerge cells excelexcel vba match functionvb 6.0 interview questions and answers for experiencedms excel offsetvba automationexcel hyperlink buttonexcel radio buttonsremove blank rows excelvba select a worksheetcompound if statement in excelhow to insert row in excelexcel formula remove duplicatestable of contents worksheetsunderstanding pivot tablesexcel event calendar templatevba excel passwordmsgbox yes noexcel macro to copy and pasteexcel merge sheets into oneprogramming in vbaexcel len functionhow to insert a hyperlink in excel