Expand Minimize

WorksheetBase.ProtectionMode Property

Gets a value that indicates whether user interface-only protection is turned on.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public bool ProtectionMode { get; }

Property Value

Type: System.Boolean
true if user interface-only protection is turned on; otherwise, false.

To turn on user interface protection, use the Protect method with the UserInterfaceOnly argument set to true.

The following code example gets the value of the ProtectionMode property to determine whether the user interface is protected. If the user interface is unprotected, then the Protect method is called with the UserInterfaceOnly parameter set to true so that the user interface is protected.

This example is for a document-level customization.

private void ProtectUserInterface()
{
    if (!this.ProtectionMode)
    {
        if (DialogResult.Yes == MessageBox.Show("User interface protection is " +
            "turned off. Turn on user interface protection?", "Example",
            MessageBoxButtons.YesNo))
        {
            // Enable user interface protection, but do not change  
            // any other protection type. 
            this.Protect(this.ProtectDrawingObjects,
                this.ProtectContents, this.ProtectScenarios,
                true, this.Protection.AllowFormattingCells,
                this.Protection.AllowFormattingColumns,
                this.Protection.AllowFormattingRows,
                this.Protection.AllowInsertingColumns,
                this.Protection.AllowInsertingRows,
                this.Protection.AllowInsertingHyperlinks,
                this.Protection.AllowDeletingColumns,
                this.Protection.AllowDeletingRows,
                this.Protection.AllowSorting,
                this.Protection.AllowFiltering,
                this.Protection.AllowUsingPivotTables);
        }
    }
}

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft