When you’re planning to work with VBA macros, you’ve to make sure that the Developer tab is present on the Excel Ribbon. The Developer tab does not appear by default. The developer tab contains useful commands for VBA users. The following figure shows the developer tab on the Excel Ribbon.
This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.
The Developer tab.
To display this tab, follow these steps:
- Right-click any Ribbon control and select Customize the Ribbon from the shortcut menu. Customize the Ribbon tab of the Excel Options dialog box appears.
Select Customize the Ribbon… from the shortcut menu.
- In the list box on the right, place a checkmark next to Developer.
- Click OK to return to Excel.
Place a checkmark next to Developer.
Happy Excelling 🙂
Read More…
Types of commands on the Ribbon
Hello!
Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!
Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!
