Remove option to sort

[Caze982]

Hi everyone

I have an Exel sheet in excel 2007 where i have some values in some columns and a filter on top of each column. When i click on the filter i also have the option to sort the different values. Is there anyway i can use vba to remove the option to filter?

 

[HackSlash]

<code>If ActiveSheet.AutoFilterMode Then ActiveSheet.ShowAllData</code>