Udostępnij za pośrednictwem


Worksheet.EnableAutoFilter Property (2007 System)

Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property EnableAutoFilter As Boolean
'Usage
Dim instance As Worksheet 
Dim value As Boolean 

value = instance.EnableAutoFilter

instance.EnableAutoFilter = value
[BrowsableAttribute(false)]
public bool EnableAutoFilter { get; set; }
[BrowsableAttribute(false)]
public:
property bool EnableAutoFilter {
    bool get ();
    void set (bool value);
}
public function get EnableAutoFilter () : boolean 
public function set EnableAutoFilter (value : boolean)

Property Value

Type: System.Boolean
true if AutoFilter arrows are enabled when user-interface-only protection is turned on; otherwise, false.

Remarks

This property applies to each worksheet and is not saved with the worksheet or session.

.NET Framework Security

See Also

Reference

Worksheet Class

Worksheet Members

Microsoft.Office.Tools.Excel Namespace