How do you make an add-in for Excel 2011 (Mac)

I would开发者_StackOverflow社区 like to add a button to the Ribbon and have it perform some basic tasks when clicked. Is this possible? If so, how?

Thanks in advance.

No, it is not possible. It looks like it is possible, but it is not. The only proper add in for Excel 2011 Mac is provided with Excel, and the ability to show it in Excel Mac's ribbon is apparently hard-coded into the Excel Mac application. None of the XML-based techniques for extending the Excel Mac ribbon work because the ribbon is hard-coded. It looks like the Windows version, but it is nothing like it.

Obviously, it is hard to provide sources for a negative answer. I have researched this topic carefully including contacting Microsoft support, and found that there is no compiler or IDE from Microsoft for this purpose. You can certainly develop in VBA in Excel Mac, and you can make an XLA add-in, but you cannot access the ribbon. You can create little square Mac toolbar icons, just as in Excel 98.

Here are some useful links that will answer your question:

• how to customize the ribbon
• how to customize the ribbon with vba
• how to create an add in (on MSDN)
• a clearer tuto on how to create an addin

Please ask a more precise question if you want more precise help.