Autofilter

Autofilter option box is greyed out and cannot be ticked. Any idea how to
get the autofilter active again.

Muzza, is the sheet protected? If this is the case, depends on what version
you are using there is an option to allow autofilter on a protected sheet,
check that box when you protect the sheet

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Muzza" <Muzza@discussions.microsoft.com> wrote in message
news:D5C0783A-866B-46C4-AED8-CB24CE1D3438@microsoft.com...
> Autofilter option box is greyed out and cannot be ticked. Any idea how to
> get the autofilter active again.

If the worksheet is protected, you won't be able to select the
AutoFilter command.
To unprotect it, choose Tools>Protection>Unprotect Sheet
You may need a password to unprotect it.

Muzza wrote:
> Autofilter option box is greyed out and cannot be ticked. Any idea how to
> get the autofilter active again.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html