Worksheet.EnableAutoFilter Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .EnableAutoFilter

expression A variable that represents a Worksheet object.

This example enables the AutoFilter arrows on a protected worksheet.

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