Autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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, 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Autofilter Arrays 5
Autofilter not grabbing last row 1
AutoFilter unavailable? 1
Is autofilter & sort disabled in protected cells? 1
Autofilter unavailable 1
How can run a macro ( call a macro) on selection of any filtercriteria? 7
How to filter only the numbers I need 3
Using Autofilter with Protection on 1

Back
Top