Skip to main content
Row

ProtectedRangeCollection Methods

A collection of items which associate worksheet ranges and security information required to unlock them for editing.
Name Description
Add(String, CellRange) Creates a new protected range and adds it to the collection.
Add(String, IList<CellRange>) Creates a protected range and adds it to a worksheet collection of protected ranges.
Add(String, String) Creates a new protected range and adds it to the collection.
Clear() Removes all items from a collection thus clearing protection ranges in a worksheet.
Contains(ProtectedRange) Determines whether the collection contains the specified protected range.
Contains(String) Determines whether the collection contains the protected range with the specified name.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
Remove(ProtectedRange) Removes the specified protected range from a collection.
Remove(String) Removes the specified protected range from a collection.
RemoveAt(Int32) Removes the element at the specified index of the ProtectedRangeCollection instance.
See Also