I am trying to make sure a colomn is sorted after a worksheet tab is clicked.
Worksheet Period1 has names in column K, this column has to be sortable by the user.(This sorts column K by Alpha and then sorts the entire worksheet accordingly.)
Worksheet Individual has combo boxes that receive these names.
I need column K on Period1 sorted Alpha (A - Z) everytime Individual is accessed, this way the names match up to the combo box reference numbers. I am calling macro's using the reference numbers.
I have tried doing this with Worksheet_Activate, but it goes into a loop, so I tried using Application.EnableEvents = False then Application.EnableEvents = True and I am not sure it has ever been set back to True. How can I confirm this?
Can anyone help me with this?
Ken
Bookmarks