The process also works for other Microsoft Office programs: Excel, PowerPoint and Word. Once the add-in is enabled you should be able to see the custom UI tab in the Ribbon. Go to Tools -> Add-ins and browse for the xlam file you created using Windows.

Go to your Mac and open Microsoft Excel for Mac. For the code I specified above, you'd need to create Sub ExportImages().įinally, close the VBA editor and click File -> Save As to save your spreadsheet as an Excel Add-in (*.xlam). Then, create a Sub that will be executed when the user clicks the button. xlsm file using Microsoft Excel for Windows.Ĭlick VBA Code to view the source code and add a new Module. Save the changes and close the application. Use the following code template for the Custom UI content.Add a Custom UI for Office 2010 using Document Explorer pane (at the right).Choose Excel Macro Enabled Workbook (*.xlsm) Here, you'll need to specify the output file. Once installed, use Run as Administrator to open the Office Ribbon Editor. NET Framework pack during the install process. Part A: Create a custom Ribbon tab for Microsoft Excel in Windows Then, go to your Mac computer and install the addin from Tools -> Addins menu. To create the ribbon, the method relies on a 3rd party software called Office Ribbon Editor. I know a workaround, but you need to be able to edit the VBA Code in Windows first and save your Macro-enabled.