You could remove the sort option and replace it with your own interface (a
userform) so you know what selections the user has made.

--
Regards,
Tom Ogilvy

"CLR" wrote:

Thanks Tom........too bad, I was hoping to be able to lite up column header
cells with the sort-key colors......oh well,

Vaya con Dios,
Chuck, CABGx3




"Tom Ogilvy" wrote:

If you mean with code,
Except by examining the data, I don't believe there is a built in method.

--
Regards,
Tom Ogilvy


"CLR" wrote:

Hi All.....
Can anyone tell me if there is a way through VBA to determine how a database
is sorted....ie: which is the 1st, 2nd, and 3rd sort keys, or even just which
is the first?

Thanks,
Vaya con Dios,
Chuck, CABGx3