WorksheetLocks Enumeration

In This Topic

Represents protected data of the worksheet.

Syntax

'Declaration
 
Public Enum WorksheetLocks 
   Inherits System.Enum

'Usage
 
Dim instance As WorksheetLocks

public enum WorksheetLocks : System.Enum

Members

Member	Description
All	All lock options
AutoFilter	Not 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.
Default	The default lock options
DeleteColumns	Not allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.
DeleteRows	Not allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.
DrawingObjects	Protect shapes.
FormatCells	Not allows the user to format any cell on a protected worksheet.
FormatColumns	Not allows the user to format any column on a protected worksheet.
FormatRows	Not allows the user to format any row on a protected.
InsertColumns	Not allows the user to insert columns on the protected worksheet.
InsertHyperlinks	Not allows the user to insert hyperlinks on the worksheet.
InsertRows	Not allows the user to insert rows on the protected worksheet.
None	Protect nothing.
PivotTables	Not allows the user to use pivot table reports on the protected worksheet.
Scenarios	Protect scenarios. This argument is valid only for worksheets.
SelectLockedCells	Not allows the user to select locked cells.
SelectUnlockedCells	Not allows the user to select unlocked cells.
Sort	Not 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