Worksheet.EnableAutoFilter Property (Excel)

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:
© 2014 Microsoft