Search Results for

    Show / Hide Table of Contents

    TSheetProtectionOptions Record

    Options for protecting a sheet.

    Syntax

    Unit: FlexCel.Core

    TSheetProtectionOptions = record;

    Fields

    Name Description
    Contents Sheet contents are protected
    Objects If TRUE, objects on the sheet are protected. Note that this setting behaves like Scenarios and opposite from all the rest.
    In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed.
    Scenarios If TRUE, scenarios on the sheet are protected. Note that this setting behaves like Objects and opposite from all the rest.
    In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed.
    CellFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    ColumnFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    RowFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    InsertColumns If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    InsertRows If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    InsertHyperlinks If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    DeleteColumns If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    DeleteRows If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    SelectLockedCells If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    SortCellRange If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    EditAutoFilters If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    EditPivotTables If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
    SelectUnlockedCells If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.

    Methods

    Name Description
    Create Overloaded
    Create
    Create(Boolean)
    Create(TProtectionType)

    Operators

    Name Description
    Equality Adapts the = operator so it returns true when both instances have the same values.
    Inequality Adapts the <> operator so it returns true when both instances have different values.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com