type
{@@ Workbook protection options }
TsWorkbookProtection = (bpLockRevision, bpLockStructure, bpLockWindows);
TsWorkbookProtections = set of TsWorkbookProtection;
{@@ Worksheet protection options. All used items are locked. }
TsWorksheetProtection = (
spFormatCells, spFormatColumns, spFormatRows,
spDeleteColumns, spDeleteRows,
spInsertColumns, spInsertRows, spInsertHyperlinks,
spCells, spSort, spObjects,
spSelectLockedCells, spSelectUnlockedCells
{spPivotTables, spScenarios }
);
TsWorksheetProtections = set of TsWorksheetProtection;
{@@ Cell protection options }
TsCellProtection = (cpLockCell, cpHideFormulas);
TsCellProtections = set of TsCellProtection;
const // all this actions are FORBIDDEN if included and ALLOWED if excluded!
ALL_SHEET_PROTECTIONS = [spFormatCells, spFormatColumns, spFormatRows,
spDeleteColumns, spDeleteRows, spInsertColumns, spInsertRows, spInsertHyperlinks,
spCells, spSort, spObjects, spSelectLockedCells, spSelectUnlockedCells
{spPivotTables, spScenarios} ];
DEFAULT_SHEET_PROTECTION = ALL_SHEET_PROTECTIONS - [spSelectLockedCells, spSelectUnlockedcells];
DEFAULT_CELL_PROTECTION = [cpLockCell];