Enable Auto Filters in protected sheet
 

Activesheet.Protect UserInterfaceOnly:=True
Activesheet.enableAutofilter = true

in xl2002 and later, this can be handled more gracefully by making that
choice in the Sheet protect dialog.


--
Regards,
Tom Ogilvy


"Gordon" wrote in message
...
Hi...

Question says it all. Auto Filters won't work when sheet is protected. Any
code to get around this?

Thanks

Gordon...