Excel Macro Add In For Mac

Macintosh Excel ONLY allows add-ins created in VBA. Therefore it is highly unlikely that conversion of a windows Excel add-in will be successful. If the Add-in is written in VBA it is perfectly possible to code it in such a way to have it work on both platforms. Get a VBA add-in for Word or Excel for Mac On the Tools menu, select Add-Ins. In the Add-Ins available box, select the add-in you want, and then click OK.

I know a workaround, but you need to be able to edit the VBA Code in Windows first and save your Macro-enabled.xlsm spreadsheet as a.xlam file. To create the ribbon, the method relies on a 3rd party software called Office Ribbon Editor. Then, go to your Mac computer and install the addin from Tools -> Addins menu. Part A: Create a custom Ribbon tab for Microsoft Excel in Windows Here are the detailed steps: • Install Office Ribbon Editor.

You'd need to download the latest.NET Framework pack during the install process. • Once installed, use Run as Administrator to open the Office Ribbon Editor. • Create a new Excel 2010 Spreadsheet. Here, you'll need to specify the output file. Choose Excel Macro Enabled Workbook (*.xlsm) • Add a Custom UI for Office 2010 using Document Explorer pane (at the right).

• Use the following code template for the Custom UI content. Edit accordingly. Code snippet: • Save the changes and close the application. • Now, open the.xlsm file using Microsoft Excel for Windows. • Enable the Developers tab in the Ribbon.

• Click VBA Code to view the source code and add a new Module. Then, create a Sub that will be executed when the user clicks the button. For the code I specified above, you'd need to create Sub ExportImages(). • Finally, close the VBA editor and click File -> Save As to save your spreadsheet as an Excel Add-in (*.xlam).

Part B: Install the add-in on Mac • Go to your Mac and open Microsoft Excel for Mac. • Go to Tools -> Add-ins and browse for the xlam file you created using Windows.

Once the add-in is enabled you should be able to see the custom UI tab in the Ribbon. Misc: The process also works for other Microsoft Office programs: Excel, PowerPoint and Word.

I didn't test the approach for Outlook add-ins. In fact, I have used this approach to make an add-in for Mac and Windows that exports all the presentation slides in PowerPoint to JPG images, with a single click. This helped me to save valuable time (for years) while uploading the to my site.