Delete options for AutoFilter?

[Jojjjo]

Hi! I have a worksheet with an autofilter. I would like to turn of the
possibility to sort by descending and ascending, and just sort on the entrys
below the header. Is there a way? (I use excel 2003)

Would really appreciate the help!

 

[ryguy7272]

Something like this?
Sub Macro2()

Range("A1:A10").Sort Key1:=Range("A1"), Order1:=xlAscending,
Header:= _
xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal


End Sub

Regards,
Ryan--

 

[Jojjjo]

It doesn't seem to work, I got an errormessage when inserting the code. Is
there another way to do it besides inserting a macro?

"ryguy7272" skrev: