I have a data validation which uses a (dynamic) drop-down list of up to 1500
names. Those names will not be entered alphabetically, and the worksheet is
protected and thus prevents the user from executing any sort to correct this.
But if it's not alphabeticized, it becomes impossible to find anything. Is
there any way to have the items in the drop-down appear in alphabetized
order? If not, what is the best way to address this? Can I point the data
validation to a "shadow" list of names which references and alphabetizes the
list the user actually enters? Create a user-executed macro which turns off
protection, alphabetizes the list, and turns protection back on?

TIA