EnableAutoFilter Property

Applies To

Worksheet object.

Description

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

Remarks

This property applies to each worksheet and isn't saved with the worksheet or session.

See Also

Protect method, Unprotect method.

Example

This example enables the AutoFilter arrows on a protected worksheet.

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