You may receive a "Macros are disabled because the security level is set to Very High" error message when you try to perform a manual payroll calculation in Small Business Accounting (908990)


The information in this article applies to:

  • Microsoft Office Small Business Accounting 2006
  • Microsoft Office Small Business Management Edition 2006

SYMPTOMS

When you when you try to perform a manual payroll calculation in Microsoft Office Small Business Accounting, 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 in Microsoft Office Excel 2003 is set to "Very High." This setting automatically disables macros on Excel 2003 worksheets. When you perform the manual payroll calculation in Excel 2003, Small Business Accounting requires that macros be enabled for the ManualPayrollCalculation.xlt worksheet.

RESOLUTION

To resolve this problem, change the macro security level in Excel 2003. To do this, follow these steps:
  1. When you receive the error message, click OK.
  2. In Excel, 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 Small Business Accounting, point to Manual Payroll on the Employees menu, and then click Enter Manual Payroll.
  7. Click to select the Always trust macros from this publisher check box.
  8. Click Enable Macros.

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 Small Business Accounting, point to Manual Payroll on the Employees menu, and then click Enter Manual Payroll.
Modification Type:MinorLast Reviewed:12/21/2005
Keywords:kbtshoot kbMBSMigrate kbprb KB908990 kbAudEndUser kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.