You may receive the error when trying to generate a "summarize payroll data" report using the "excel--->summarize payroll data in excel" option in QuickBooks employee center or when trying to generate a letter in QuickBooks.
To change the macro security level in either MS Excel or Word
Microsoft Office 2007 and 2010:
Microsoft Office 2003:
If this solution does not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free, or you can contact a technical support agent for additional guidance. Fees may apply.