Autofilter in Excel has stopped availability! 1

[duncansancho]

Hello all,
This morning when I ran a routine which I use several times a day, I did not get the expected result. The reason turns out to be that I can no longer use the autofilter in Excel. What is wrong and how do I fix it Please.
Duncan

 

[PHV]

I can no longer use the autofilter in Excel
Any error message ?
Have you tried to debug your code step by step ?
Can you autofiltering manually ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[duncansancho]

Hi PH
I tried debugging manually but the only problem is that autofilter does not work. It has stopped being available manually as well in that file. Other files are not affected.
Duncan

 

[xlbo]

has the sheet got protected ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[duncansancho]

Geoff
That's it! I feel very stupid for not thinking of it and I'm not sure how it happened but that is the answer. Thanks a million