Solution for VBA problems: Completely remove the Mac Office 2011 suite and then reinstall the whole suite without using the Migration Assistant. On the topmost menu, choose Excel > Close and Return to Microsoft Excel. If you get this far, then VBA is likely fine. On the new topmost menu, choose Insert > Module. (B) Is VBA installed and working? To check, choose Tools > Macro > Visual Basic Editor. To verify VBA problems: (A) Can you record a macro? To check, choose Tools > Macro > Record New Macro… If the Record Macro dialog box appears, it’s working. Specifically, the Migration Assistant may not transfer the Mac Excel 2011 VBA features reliably. There have been reports (and it is our experience) that the Migration Assistant is not successful when it is used to transfer Mac Office 2011 from one computer to another. Possible cause: Mac Excel 2011 was installed using the Apple Migration Assistant (which can be used to transfer Mac Excel 2011 from another computer to the current computer).
Problem: In Mac Excel 2011, you try to run a VBA add-in (TreePlan, SensIt, or SimVoi) and receive an error message like “Error in loading DLL,” “Excel could not open (the XLAM add-in file name) because some content is unreadable …,” or “Excel repaired or removed unreadable content from this workbook …”