I have a list of data that I want to ensure is sorted when the user exits
from the worksheet.

Today I have a button with a macro attached to it (sort_data). But the user
will have to actually push the button. If he forgets there is a risk that
functions like INDEX in other sheets won't work properly....

Can I use VBA to detect worksheet exit and trigger the sort macro before
leaving?