Workbook.WritePassword Property (2007 System)

Gets or sets the write password of a workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

public string WritePassword { get; set; }

Property Value

Type: System.String
The write password of a workbook.

The WritePassword property is readable and returns ">>**".

The following code example uses the WriteReserved property to determine whether the current workbook is write-reserved. If the workbook is not write-reserved, then the method sets the WritePassword property to a password obtained through user input. Otherwise, the example uses the WriteReservedBy property to display the name of the user who saved the workbook as write-reserved. This example assumes the existence of a method named GetPasswordFromUserInput that obtains a strong password from user input.

This example is for a document-level customization.

private void SetWritePassword()
    if (!this.WriteReserved)
        this.WritePassword = GetPasswordFromUserInput();
        MessageBox.Show("This workbook was saved as Write Reserved." +
            " Please contact " + this.WriteReservedBy + " to add data.");

Community Additions