officefileapi-devexpress-dot-spreadsheet-dot-worksheet-dot-unprotect-x28-system-dot-string-x29.md
Removes protection from a worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool Unprotect(
string password
)
Function Unprotect(
password As String
) As Boolean
| Name | Type | Description |
|---|---|---|
| password | String |
A string that specifies the password with which the worksheetis protected.
|
| Type | Description |
|---|---|
| Boolean |
true , if protection is successfully removed; otherwise, false.
|
If the worksheet is not protected, the Unprotect method raises an exception. Use the Workbook.IsProtected property to check whether the worksheet is already protected.
Worksheet worksheet = workbook.Worksheets("ProtectionSample");
workbook.Worksheets.ActiveWorksheet = worksheet;
// Remove worksheet protection (requires the password).
if (worksheet.IsProtected) {
worksheet.Unprotect("password");
}
// Add a note.
worksheet("B2").Value = "Worksheet is unprotected. You can edit and format cells.";
worksheet.Visible = true;
Dim worksheet As Worksheet = workbook.Worksheets("ProtectionSample")
workbook.Worksheets.ActiveWorksheet = worksheet
' Remove worksheet protection using a password.
If worksheet.IsProtected Then
worksheet.Unprotect("password")
End If
' Add a note.
worksheet("B2").Value = "Worksheet is unprotected. You can edit and format cells."
worksheet.Visible = True
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Unprotect(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.
if (worksheet.IsProtected)
worksheet.Unprotect("password");
// Add a note.
If worksheet.IsProtected Then
worksheet.Unprotect("password")
End If
See Also