Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

AutoFilter Command wouldn't work

Posted by Carlo on January 02, 2001 4:24 AM

I don't know exactly what happened to my worksheet, but the AutoFilter is greyed out and doesn't work anymore. There are no hidden columns or rows and the worksheet is not protected. Any ideas?

Re: AutoFilter Command wouldn't work

Posted by Dave on January 02, 2001 4:39 AM

Hi Carlo

Do you have any Auto_openor Auto_Close Macros that would cause this?

Try running this code, if the worksheet is not protected it should work:

Sub FilterUnGrey()
Application.CommandBars("Worksheet Menu Bar").Controls _
("&Data").Controls("&Filter").Controls("Auto&Filter").Enabled = True
End Sub

Dave

OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.