MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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