Excel: Developer tab

Show (Hide) Developer tab on Ribbon

In order to have the record macro button, the Developer tab must be first enabled (See also recording macros in Excel)

This can be done in the registry under HKEY_CURRENT_USER\Software\Microsoft\Office\_version_\Excel\Options (value DeveloperTools).

Alternatively, the developer tools can also be enabled via the menu: File -> Options -> Customize Ribbon -> Check Developer box on right side.

With VBA, the state of the developer tab can be queried or modified with application.showDevTools:

application.showDevTools = true