GrapeCity.Spreadsheet.WorksheetLocks

WorksheetLocks Enum

Represents protection options of a worksheet.

public enum WorksheetLocks : short

Public Enum WorksheetLocks As Short

Name	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.
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.
Objects	Protect objects.
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.