Sort rows from validation list value, but not using the Worksheet_SelectionChange?

[buckwheat4948]

Is it possible to either create a validation that sorts the rows depending on the value selected, but not using the Worksheet_SelectionChange or activating a macro when clicking on cell A9, but from the workbook_activate?

Oh im stupid, i think i can use formula 2 from the validation list to sort rows based on the value clicked?

Basically I have a workbook that creates sheets automatically every so often. The workbook creates sheets with data, but i'd like the sheet to be completely automated.

Id like to sort rows A10:$A$20 based on the value clicked on the validation list.

The workbook creates a validation list in the new sheets by:
With NewSheet.Range("A9").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:=strList
.IgnoreBlank = True
.InCellDropdown = True
End With

Or can i add code to the Worksheet_SelectionChange from the workbook_activate? Or maybe another option...

Thanks!