Skip to main content
Row

ProtectedRange.SetPassword(String) Method

Specifies the password that unlocks a range on a protected worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void SetPassword(
    string password
)

Parameters

Name Type Description
password String

A string that is the password that the end-user must enter to edit the protected range.

Remarks

When the end-user attempts to edit cells in a protected range on a protected sheet, the Unlock Range dialog appears prompting for a password. Entering the string specified by the SetPassword method unlocks the worksheet range specified by the ProtectedRange.Range or the ProtectedRange.RefersTo properties.

You can also specify a ProtectedRange.SecurityDescriptor which enables particular users to edit the range without entering the password.

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetPassword(String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also