How to enable Developer tab in excel 2007

Enable Developer tab in excel 2007 (with Images)

What is a Developer Tab:  This tab need to be accessed when we are developing or running macros using Visual Basic to use with Microsoft Office programs.

Why is it important: This tab contains lots tools which are essentials when we are creating  applications to use with Microsoft Office programs. For example to insert From Controls and ActiveX Controls while creating a macro.

How to enable Developer Tab in Excel 2007

Step 1: Open a new excel and click on Excel Options.

enable Developer tab in excel 2007

Step 2: Popular menu – Show Developer tab in the Ribbon and click the Tick mark to enable Developer tab and then click OK.

enable developer tab

Once enabled it appears along with the top row commands of other Excel Ribbon items.

Check out:

How to enable Developer Tab in Excel 2010

About Anson

I’m Anson having a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema, I do make Short Films 🙂


  1. Pingback: How to enable Developer tab in excel 2007 | asK...

  2. Ronald Hockins

    I simply want to mention I am just all new to blogging and site-building and actually loved this page. Most likely I’m planning to bookmark your site . You actually come with superb posts. Thank you for sharing with us your website.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.