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"

View products that this article applies to.

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.

Back to the top

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.

Back to the top

RESOLUTION

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

Back to the top

Method 1: Change the macro security level in Excel 2003

When you receive the error message, click OK.
In Excel 2003, open the Microsoft Excel ManualPayrollCalculation.xlt worksheet, point to Macro on the Tools menu, and then click Security.
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.
Click OK.
Close the Excel worksheet. To do this, click Exit on the File menu.
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.
Click to select the Always trust macros from this publisher check box.
Click Enable Macros.

Back to the top

Method 2: Change the macro security level in Excel 2007

When you receive the error message, click OK.
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.
On the Macro Settings tab, select the Disable all macros except digitally signed macros option.
Click OK.
Click the Office Button, and then click Exit Excel.
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.
Next to the Security Warning message that appears in the toolbar, click Options.
Select the Enable this content option, and then click OK.

Back to the top

MORE INFORMATION

Steps to reproduce the behavior

Open Excel 2003.
On the Tools menu, point to Macro, and then click Security.
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.
On the Trusted Publishers tab, click Microsoft Corporation, and then click Remove.
Click OK.
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.