MS Excel VBA: How to add Developer tab in Microsoft Excel?

Programming in 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 VBA.

1. Go to File -> Options

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

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.

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


2. Customize from ribbon level

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.

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.

Check if your Developer tab is visible now! 🙂

If you enjoyed this post please add the comment below or share this post on your Facebook, Twitter, LinkedIn or another social media webpage.
Thanks in advanced!

0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments