WorkbookBase.UnprotectDocument Method

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assembly:

Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Called by the Visual Studio Tools for Office runtime so that you can remove password protection from the workbook and enable cached data to be saved.

protected:
 virtual void UnprotectDocument();

protected virtual void UnprotectDocument ();

abstract member UnprotectDocument : unit -> unit
override this.UnprotectDocument : unit -> unit

Protected Overridable Sub UnprotectDocument ()

Examples

The following code example demonstrates how to override the UnprotectDocument method to temporarily unprotect the workbook so that changes to the cached data can be saved. The example first saves the current ProtectStructure and ProtectWindows values, so that the same type of protection can be reapplied later in the ProtectDocument method. To use this code, run it from the ThisWorkbook class in a document-level project for Excel. The code assumes that the password is stored in a field named securelyStoredPassword.

[CachedAttribute]
public string CachedString = "This string is cached in the workbook.";

private bool protectStructureValue;
private bool protectWindowsValue;

protected override void UnprotectDocument()
{
    protectStructureValue = this.ProtectStructure;
    protectWindowsValue = this.ProtectWindows;

    this.Unprotect(securelyStoredPassword);
}

protected override void ProtectDocument()
{
    this.Protect(securelyStoredPassword, protectStructureValue,
        protectWindowsValue);
}

<CachedAttribute()> _
Public CachedString As String = "This string is cached in the workbook."

Private protectStructureValue As Boolean
Private protectWindowsValue As Boolean

Protected Overrides Sub UnprotectDocument()
    protectStructureValue = Me.ProtectStructure
    protectWindowsValue = Me.ProtectWindows

    Me.Unprotect(securelyStoredPassword)
End Sub

Protected Overrides Sub ProtectDocument()
    Me.Protect(securelyStoredPassword, protectStructureValue, _
        protectWindowsValue)
End Sub

Remarks

Override this method in a document-level project for Excel if your workbook is protected by using a password, and it contains cached data that might be changed at run time. In your implementation of this method, use the Unprotect method to temporarily unprotect the workbook.

By default, changes to cached data in a password-protected workbook are not persisted when the workbook is saved. To save changes to the cached data, you must override the following methods in your project:

• UnprotectDocument. When the workbook is saved, the Visual Studio Tools for Office runtime calls this method. Add code to this method that temporarily unprotects the workbook. This enables changes to the cached data to be saved.

• ProtectDocument. After the workbook is saved, the Visual Studio Tools for Office runtime calls this method. Add code to this method that reapplies protection to the workbook.

For more information, see How to: Cache Data in a Password-Protected Document.