Worksheet.EnableAutoFilter property (Excel)

True if AutoFilter arrows are enabled when user-interface-only protection is turned on. Read/write Boolean .

Syntax

expression. EnableAutoFilter

expression A variable that represents a Worksheet object.

Example

This example enables the AutoFilter arrows on a protected worksheet.

ActiveSheet.EnableAutoFilter = True 
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True

See also

Worksheet Object