How to show the Developer Tab on the Ribbon

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:

1. 1. 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.

1. In the list box on the right, place a checkmark next to Developer.
2. Click OK to return to Excel.

Place a checkmark next to Developer.

Happy Excelling 🙂

Read More…

Types of commands on the Ribbon