There are however, apparently, according to Microsoft Helpdesk, some third party applications that can address problems with the VBA interface with Office for Mac.

Purchasing the Home Premium version of Office for Mac will not allow telephone support automatically to query any problems with the VBA interface. Support for Visual Basic for Applications macros has returned after having been dropped in Office 2008. Its interface is now more similar to Office 20 for Windows, with the addition of the ribbon. Microsoft Office 2011 includes more robust enterprise support and greater feature parity with the Windows edition.