ActiveX

To allow users to sort columns

1. If you want to prevent the user from sorting on a specific column, set the ColUserSortIndicator property as follows.
   1. Specify the column number using the Col parameter.
   2. Set the property to 3 (Disabled).
2. Set the UserColAction property to one of the following values to specify what action to perform when the user clicks any column header:
   • If you want the column to be sorted when the user clicks a column header and to display the sort indicator, set the UserColAction property to 1 (Sort).
   • If you want the column to be sorted when the user clicks a column header and to not display the sort indicator, set the UserColAction property to 2 (SortNoIndicator).
3. If your sheet displays multiple headers and you want the sort indicator to display in a row other than the bottom-most header row, specify which column header row will display the indicator by setting the ColHeadersUserSortIndex property.