How to customize the Excel (and Office) Ribbon
Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3) | Microsoft Docs (...) To create an Excel workbook that is macro-enabled Start Excel 2007. Click the Developer tab, and then click Visual Basic . Note If you do not see the Developer tab, you must identify yourself as a developer. To do this in your application, click the Microsoft Office Button , click Application Options , click Popular , and then select Show Developer Tab in the Ribbon . This is a global setting that identifies you as a developer in all Office applications that implement the Fluent UI. In the Visual Basic Editor, double-click ThisWorkbook to open the Code window. Type the following VBA function, and then click the Excel icon in the left corner of the toolbar to return to Excel. VB Copy Sub MyMacro( ByVal control as IRibbonControl) MsgBox( "Hello World" ) End Sub Save the document as a macro-enabled workbook with the file name extension .xlsm. Note If you save the d