officefileapi-devexpress-dot-spreadsheet-dot-protectedrangecollection-dot-add-x28-system-dot-string-devexpress-dot-spreadsheet-dot-cellrange-x29.md
Creates a new protected range and adds it to the collection.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ProtectedRange Add(
string name,
CellRange range
)
Function Add(
name As String,
range As CellRange
) As ProtectedRange
| Name | Type | Description |
|---|---|---|
| name | String |
A string that is the name of the new protected range.
| | range | CellRange |
A CellRange which can be edited in a protected sheet.
|
| Type | Description |
|---|---|
| ProtectedRange |
A ProtectedRange object that is the newly added element in the collection.
|
The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(String, CellRange) 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.
// Give specific user permission to edit a range in a protected worksheet.
ProtectedRange protectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet["C3:E8"]);
EditRangePermission permission = new EditRangePermission();
// Give specific user permission to edit a range in a protected worksheet
ProtectedRange protectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet["C3:E8"]);
EditRangePermission permission = new EditRangePermission();
// Specify user permission to edit a range in a protected worksheet.
ProtectedRange protectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet["B2:J5"]);
EditRangePermission permission = new EditRangePermission();
' Give specific user permission to edit a range in a protected worksheet.
Dim protectedRange As ProtectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet("C3:E8"))
Dim permission As New EditRangePermission()
' Give specific user permission to edit a range in a protected worksheet
Dim protectedRange As ProtectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet("C3:E8"))
Dim permission As New EditRangePermission()
' Specify user permission to edit a range in a protected worksheet.
Dim protectedRange As ProtectedRange = worksheet.ProtectedRanges.Add("My Range", worksheet("B2:J5"))
Dim permission As New EditRangePermission()
See Also
ProtectedRangeCollection Interface