Spread Windows Forms 18
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / WorksheetLocks Enumeration


In This Topic
    WorksheetLocks Enumeration
    In This Topic
    Represents protection options of a worksheet.
    Syntax
    'Declaration
     
    
    Public Enum WorksheetLocks 
       Inherits System.Enum
    'Usage
     
    
    Dim instance As WorksheetLocks
    public enum WorksheetLocks : System.Enum 
    Members
    MemberDescription
    AllAll lock options
    AutoFilterNot allows the user to set filters on the protected worksheet. Users can change filter criteria but can not enable or disable an auto filter. Users can set filters on an existing auto filter.
    DefaultThe default lock options
    DeleteColumnsNot allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.
    DeleteRowsNot allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.
    FormatCellsNot allows the user to format any cell on a protected worksheet.
    FormatColumnsNot allows the user to format any column on a protected worksheet.
    FormatRowsNot allows the user to format any row on a protected.
    InsertColumnsNot allows the user to insert columns on the protected worksheet.
    InsertHyperlinksNot allows the user to insert hyperlinks on the worksheet.
    InsertRowsNot allows the user to insert rows on the protected worksheet.
    NoneProtect nothing.
    ObjectsProtect objects.
    PivotTablesNot allows the user to use pivot table reports on the protected worksheet.
    ScenariosProtect scenarios. This argument is valid only for worksheets.
    SelectLockedCellsNot allows the user to select locked cells.
    SelectUnlockedCellsNot allows the user to select unlocked cells.
    SortNot allows the user to sort on the protected worksheet. Every cell in the sort range must be unlocked or unprotected.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Spreadsheet.WorksheetLocks

    See Also