If you look at that code again, you'll see that the custom list was added in the
macro.



Dennis Cheung wrote:

but it didn't work for other users they don't have this order built.
can i save the order in a file? or write it in a marco?

Dennis

"Carim" wrote in message
oups.com...
Dennis,

Go and create your own custom list...
follow Tools Options Custom Lists
Then once your list is built, it becomes available in the standard Data
Sort, where you select your new list as the sort option ...
HTH
Carim


--

Dave Peterson