T Tom Ogilvy Oct 9, 2003 #2 Activesheet.enableAutofilter = True Activesheet.Protect UserInterfaceOnly:=True The autofilter already has to be in place with the dropdown arrows showing.
Activesheet.enableAutofilter = True Activesheet.Protect UserInterfaceOnly:=True The autofilter already has to be in place with the dropdown arrows showing.