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

C#

void SetPassword(
    string password
)

VB.NET

Sub SetPassword(
    password As String
)

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.

Related GitHub Examples

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.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/ProtectionActions.cs#L81

protectedRange.SecurityDescriptor = protectedRange.CreateSecurityDescriptor(new EditRangePermission[] { permission });
protectedRange.SetPassword("123");
// Protect the worksheet with a password.

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/ProtectionActions.cs#L62

protectedRange.SecurityDescriptor = protectedRange.CreateSecurityDescriptor(new EditRangePermission[] { permission });
protectedRange.SetPassword("123");

VB.NET

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/ProtectionActions.vb#L65

protectedRange.SecurityDescriptor = protectedRange.CreateSecurityDescriptor(New EditRangePermission() { permission })
protectedRange.SetPassword("123")

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/ProtectionActions.vb#L69

protectedRange.SecurityDescriptor = protectedRange.CreateSecurityDescriptor(New DevExpress.Spreadsheet.EditRangePermission() {permission})
protectedRange.SetPassword("123")
' Protect the worksheet with a password.

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/ProtectionActions.vb#L67

protectedRange.SecurityDescriptor = protectedRange.CreateSecurityDescriptor(New EditRangePermission() { permission })
protectedRange.SetPassword("123")