Microsoft KB Archive/908990

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

Article ID: 908990

Article Last Modified on 10/29/2007

-

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 Accounting 2006
 * Microsoft Office Small Business Management Edition 2006

-





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 &quot;Very High&quot; 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
 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.</li> Click to select the Always trust macros from this publisher check box.</li> Click Enable Macros.</li></ol>

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.

<div class="moreinformation_section">

Steps to reproduce the behavior
<ol> Open Excel 2003.</li> On the Tools menu, point to Macro, and then click Security.</li> 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.'''

</li> On the Trusted Publishers tab, click Microsoft Corporation, and then click Remove.</li> Click OK.</li> 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.</li></ol>

Additional query words: MOA

Keywords: kbtshoot kbprb kbmbsmigrate KB908990

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.