Description
Represents options of worksheet protection.

Namespace: Docs.Excel
Assembly: Excel (in Excel.dll) Version: 3.1.0.0 (3.1)

Syntax

         
 C#  Visual Basic  Visual C++ 
public class ExcelWorksheetProtection
Public Class ExcelWorksheetProtection
public ref class ExcelWorksheetProtection

Members

            
 All Members  Constructors   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
ExcelWorksheetProtection()()()()
Initializes a new instance of class ProtectedSheet.
AutoFilter
Autofilters are locked when the sheet is protected.
DeleteColumns
Column Deleting is locked when the sheet is protected.
DeleteRows
Row Deleting is locked when the sheet is protected.
FormatCells
Formatting cells are locked when the sheet is protected.
FormatColumns
Column Formatting is locked when the sheet is protected.
FormatRows
Row Formatting is locked when the sheet is protected.
InsertColumns
Column Inserting is locked when the sheet is protected.
InsertHyperlinks
Inserting of hyperlink is locked when the sheet is protected.
InsertRows
Row Inserting is locked when the sheet is protected.
IsProtected
The sheet is protected if True; otherwise - false.
Objects
Objects are locked when the sheet is protected.
Password
Sets a password protection of worksheet.
PivotTables
Pivot tables are locked when the sheet is protected.
Scenarios
Scenarios are locked when the sheet is protected.
SelectLockedCells
Selection of locked cells is locked when the sheet is protected.
SelectUnlockedCells
Selection of unlocked cells is locked when the sheet is protected.
SetHashPassword(Int16)
SetHashPassword(String)
Sort
Sorting is locked when the sheet is protected.

Inheritance Hierarchy

System..::..Object
  Docs.Excel..::..ExcelWorksheetProtection

See Also