Excel VBA Programmatically add button to Ribbon

Hiw to Run a Macro in excel

Excel VBA Ribbon Control

If you are dealing with macros in Excel for the first time, you will quickly come across the first problem: There is neither a button in the ribbon to start the VBA editor nor an option to record macros. However, this can be corrected with a few mouse clicks.
Open backstage view

The features, which Microsoft has accommodated in versions before Excel 2007 still under extras / macro, are now on the tab developer tools. However, this tab is not found in the ribbon by default.

To display the ribbon, first navigate to Backstage View by clicking the File tab. Now select Options in the left pane below, and in the pane that opens, go to Customize Ribbon.

Adjust ribbon

A number of options are now available on the right side of the dialog box. For our purposes, only the pull-down list Customize Ribbon is relevant. Now activate the checkbox Developer Tools by ticking and click OK - done.

You will then return to the normal view of Microsoft Excel. On the graphical user interface, the Developer Tools tab has now latched into the ribbon. When you click on this tab, several groups are displayed.

Excel VBA Programmatically add button to Ribbon.

Probably the most important of these is code. Here you will find buttons that can be used to start the VBA editor, record macros, or directly call previously created ones.