Autofilter

M

Muzza

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

Debra Dalgleish

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.
 
P

Paul B

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
 
Top