WorksheetBase.EnableSelection Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets a value indicating which cells can be selected on the sheet.

public:
 property Microsoft::Office::Interop::Excel::XlEnableSelection EnableSelection { Microsoft::Office::Interop::Excel::XlEnableSelection get(); void set(Microsoft::Office::Interop::Excel::XlEnableSelection value); };

public Microsoft.Office.Interop.Excel.XlEnableSelection EnableSelection { get; set; }

member this.EnableSelection : Microsoft.Office.Interop.Excel.XlEnableSelection with get, set

Public Property EnableSelection As XlEnableSelection

Property Value

XlEnableSelection

One of the XlEnableSelection values.

Examples

The following code example uses the Protect method to protect the worksheet, and then uses the EnableSelection property to prevent any cell on the worksheet from being selected.

This example is for a document-level customization.

private void ProtectAndDisableSelection()
{
    this.Protect(true, true, true, true, true,
        false, false, false, false, false, false, false, true,
        true, true);
    this.EnableSelection = Excel.XlEnableSelection.xlNoSelection;
}

Private Sub ProtectAndDisableSelection()
    Me.Protect(DrawingObjects:=True, Contents:=True, Scenarios:=True, _
        UserInterfaceOnly:=True, AllowFormattingCells:=True, _
        AllowFormattingColumns:=False, AllowFormattingRows:=False, _
        AllowInsertingColumns:=False, AllowInsertingRows:=False, _
        AllowInsertingHyperlinks:=False, AllowDeletingColumns:=False, _
        AllowDeletingRows:=False, AllowSorting:=True, AllowFiltering:=True, _
        AllowUsingPivotTables:=True)
    Me.EnableSelection = Excel.XlEnableSelection.xlNoSelection
End Sub

Remarks

This property takes effect only when the worksheet is protected: xlNoSelection prevents any selection on the sheet, xlUnlockedCells allows only those cells that are not locked to be selected, and xlNoRestrictions allows any cell to be selected.

Applies to

Udostępnij za pośrednictwem