MACROS
How to activate the Developer tab
Did you know that besides regular tabs that Excel shows to us by default, you can activate some hidden ones? One of them is the Developer tab.
When activated, the Developer tab provides to us specific commands which we can use for creating and running Excel VBA macros. Here below you can find what is inside of it.
As you can see, here you can trigger macro recording, open Visual Basic editor, run already created macros and much more. So, how to activate the Developer tab?
You can activate it by following further steps:
- Go to Excel Options
- Select Popular
- Check the option Show Developer tab in the Ribbon
- Click OK button to confirm selection
Now when you know how to activate the Developer tab, and are more familiar with custom Excel functionalities, it is the right time to start learning Microsoft Excel VBA programming and see what it can bring to you.
If you need some additional advice or consultation related to Excel VBA Macros, please be free to write to us your issue or question. We are glad that we can be of service and will answer to your request promptly.