It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007. In my example, I have created a new tab, labeled Custom Ribbon Tab, with a single group, labeled Custom Group, containing a large button, Macro 1 two small buttons, Macro 2 and Macro 3 and a split button, Macro 4. It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. Click on the Developer checkbox under the list of Main Tabs on the. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. When the Excel Options window appears, click on the Customize Ribbon option on the left. You can use Office 2007/2010/2013/2016 immediately without any training. Click the OK button to finish customizing.įigure 2: Add Developer Tab into Excel 2010 Ribbonīrings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365.At the right, select the Main Tabs from Customize The Ribbon drop down box Press with right mouse button on on the ribbon -> Customize the Ribbon.Click the Customize Ribbon at the left.Click the Options at the left to enter into Excel Option window.How to add Developer Tab into Excel 20 Ribbon: Return to Excel, right click anywhere on the Ribbon, and choose Customize the Ribbon to display the Customize Ribbon tab in the Excel Options dialog box. Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option.įigure 1: Add Developer Tab into Excel 2007 Ribbon.Click the Excel Option button at the bottom, then you will enter the Excel Option window.How to add Developer tab into Excel 2007 Ribbon? But I found the custom ribbon file was stored in a fix path, so you could try moving the file to the fix path. As Eugene mentioned, there is no such method through Excel Object Model. Classic Menu for Office Home and Business We could use Workbooks.Open Method (Excel) while opening a workbook and use Workbook.BeforeClose Event (Excel) while closing a workbook.Classic Menu for Office 2007 Applications.