unable to enable macros in excel 2010 - MSDN - Microsoft

Trust Center -> Macro Settings -> "Trust access to the VBA project model ... if it could help you: Macros enabled but 'record macro' is grayed out.

social.msdn.microsoft.com