Microsoft KB Archive/914199

= Error message when you try to unprotect an IRM-protected workbook programmatically in Excel 2003: &quot;Run-time error: 1004&quot; =

Article ID: 914199

Article Last Modified on 3/7/2006

-

APPLIES TO


 * Microsoft Office Excel 2003

-





SYMPTOMS
Consider the following scenario. You open a workbook that you helped protect by using Information Rights Management (IRM) in Microsoft Office Excel 2003. Then, you try to unprotect the IRM-protected workbook programmatically by using the Unprotect method. In this scenario, the workbook is not unprotected. If you try to help reprotect the workbook programmatically by using the Protect method, the workbook is not reprotected. Additionally, you receive one or more of the following error messages.

Error message 1

Run-time error: 1004

Error message 2

Protect Run-time error '1004': Application-defined or object-defined error

Error message 3

Unprotect Run-time error '1004': Unprotect method of Worksheet class failed



STATUS
This behavior is by design.



MORE INFORMATION
For more information about how to use Information Rights Management in Excel 2003, click the following article number to view the article in the Microsoft Knowledge Base:

826923 Description of options that help you protect your worksheets in Excel 2003 and Excel 2002

Additional query words: excel2003 excel2k3 xl2003 xl2k3

Keywords: kbvba kbautomation kbtshoot kbexpertisebeginner kbprb KB914199

-

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

© Microsoft Corporation. All rights reserved.