WorksheetBase.EnableSelection Property
Gets or sets a value indicating which cells can be selected on the sheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Property EnableSelection As XlEnableSelection
Get
Set
public XlEnableSelection EnableSelection { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlEnableSelection
One of the XlEnableSelection values.
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.
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 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
private void ProtectAndDisableSelection()
{
this.Protect(missing, true, true, true, true, true,
false, false, false, false, false, false, false, true,
true, true);
this.EnableSelection = Excel.XlEnableSelection.xlNoSelection;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.