record a macro to do what you want. When you're done, create a button (use
the Forms toolbar - View/Toolbars/Forms), assign it to the macro you just
recorded.

"john" wrote in message
...
I have a list which I update regularly and need it to be kept in a certain
order. But everytime I go to sort it I have to choose all the same
options
again (no header, sort by column D, column B, column A).

Is there any way to set all these options so I can just press a button and
it automatically searches using these options? Or better yet an automatic
sorting of rows in realtime?