You are currently viewing MS Excel VBA How to add Developer tab in Excel? – 2 quick & short steps!
Could You Please Share This Post? I Appreciate It And Thank YOU! :) Have A Nice Day!
4.9
(591)

In this tutorial we will focus on topic: MS Excel VBA How to add Developer tab in Excel. Programming in MS Excel VBA can significantly speed up and facilitate your work. Visual Basic for Applications is a programming language implemented in Microsoft Office programs that you can use to write macros. So what is a macro? Macro are programs that can automate your work.

In this post I will show you how to add Developer tab in two ways which you need to start your adventure with programming in VBAcheck another post regarding VBA!

MS Excel VBA How to add Developer tab in Excel

1. Go to File -> Options

The first way to add a Developer setting is select File in the toolbar and then Options.

MS Excel VBA How to add Developer tab in Excel? - 2 quick & short steps!
Show the Developer tab

You will see the new window that allow you customize your ribbon. In Customize the Ribbon check list, select Developer option and next click OK.

MS Excel VBA How to add Developer tab in Excel? - 2 quick & short steps!
Enable Developer Tab in Excel

Done! Now you can see the Developer tab on your ribbon.


2. Customize from ribbon level to have MS Excel VBA enabled

The second way to add a Developer tab is to customize it from the ribbon level. Right-click in a free ribbon field and you should see the two options: Customize the Ribbon and Collapse the Ribbon. Select the first option.

MS Excel VBA How to add Developer tab in Excel? - 2 quick & short steps!
Display the Developer tab in the toolbar

You will see the new window that allow you customize your ribbon. In Customize the Ribbon check list, select Developer option and next click OK.

MS Excel VBA How to add Developer tab in Excel? - 2 quick & short steps!

Check if your Developer tab is visible now! 🙂

MS Excel VBA How to add Developer tab in Excel? - 2 quick & short steps!

That’s all about: MS Excel VBA How to add Developer tab in Excel or Display the Developer tab in the toolbar!

Could You Please Share This Post? 
I appreciate It And Thank YOU! :)
Have A Nice Day!

BigData-ETL: image 7YOU MIGHT ALSO LIKE

How useful was this post?

Click on a star to rate it!

Average rating 4.9 / 5. Vote count: 591

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?