Error message when you try to perform a manual payroll calculation in Accounting Professional, in Accounting Express, and in Small Business Accounting 2006: "Macros are disabled because the security level is set to Very High"

Article translations Article translations
Article ID: 908990 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you when you try to perform a manual payroll calculation in Microsoft Office Accounting Professional, in Microsoft Office Accounting Express, or in Microsoft Office Small Business Accounting 2006, you may receive the following error message:
Macros are disabled because the security level is set to Very High. To run the macros, change the security level to a lower setting and verify the macros are signed and trusted.

CAUSE

This problem occurs because the macro security level is set to "Very High" in Microsoft Office Excel 2003 worksheets or in Microsoft Office Excel 2007 worksheets. This setting automatically disables macros in Excel 2003 worksheets and in Excel 2007 worksheets. When you perform the manual payroll calculation in Excel 2003 or in Excel 2007, these programs require that macros be enabled for the ManualPayrollCalculation.xlt worksheet.

RESOLUTION

To resolve this problem, change the macro security level. To do this, use one of the following methods.

Method 1: Change the macro security level in Excel 2003

  1. When you receive the error message, click OK.
  2. In Excel 2003, open the Microsoft Excel ManualPayrollCalculation.xlt worksheet, point to Macro on the Tools menu, and then click Security.
  3. On the Security Level tab, select the following option:
    High. Only signed macros from trusted sources will be allowed to run. Unsigned macros are automatically disabled.
  4. Click OK.
  5. Close the Excel worksheet. To do this, click Exit on the File menu.
  6. In Accounting Professional, in Accounting Express, or in Small Business Accounting 2006, point to Manual Payroll on the Employees menu. Then, click Enter Manual Payroll.
  7. Click to select the Always trust macros from this publisher check box.
  8. Click Enable Macros.

Method 2: Change the macro security level in Excel 2007

  1. When you receive the error message, click OK.
  2. In Excel 2007, open the Microsoft Excel ManualPayrollCalculation.xlt worksheet, click the Office Button, click Excel Options, click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. On the Macro Settings tab, select the Disable all macros except digitally signed macros option.
  4. Click OK.
  5. Click the Office Button, and then click Exit Excel.
  6. In Accounting Professional, in Accounting Express, or in Small Business Accounting 2006, point to Manual Payroll on the Employees menu. Then, click Enter Manual Payroll.
  7. Next to the Security Warning message that appears in the toolbar, click Options.
  8. Select the Enable this content option, and then click OK.

MORE INFORMATION

Steps to reproduce the behavior

  1. Open Excel 2003.
  2. On the Tools menu, point to Macro, and then click Security.
  3. On the Security Level tab, select the following option:
    Very High. Only macros installed in trusted locations will be allowed to run. All other signed and unsigned macros are disabled.
  4. On the Trusted Publishers tab, click Microsoft Corporation, and then click Remove.
  5. Click OK.
  6. In Accounting Professional, in Accounting Express, or in Small Business Accounting 2006, point to Manual Payroll on the Employees menu, and then click Enter Manual Payroll.

Properties

Article ID: 908990 - Last Review: September 10, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Office Accounting Professional 2008
  • Microsoft Office Accounting Express 2008
  • Microsoft Office Accounting Professional 2007
  • Microsoft Office Accounting Express 2007
  • Microsoft Office Small Business Management Edition 2006
Keywords: 
kbtshoot kbmbsmigrate kbprb KB908990

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com