I would suggest that your workSHEET is protected under ToolsProtection


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 12:32:01 -0700, YanYan
wrote:

Why would the auto filter option be grayed out on my workbook? I dont have a
workbook protection on and can't figure out what other reasons would make it
gray out. Only my advance filter option is available.