Auto sort

Question

Curios. I have a sheet with a range A1:A20 that needs to be Filtered A-Z for some formulas to work on other sheets. I have a macro set up to do this but other people that use sheet might not remember to do this. Is there a vba code that i can write to the sheet that if they leave that page that range would be sorted upon exiting sheet

Answer 1

That will work for now, but I'll leave this open to see if any one has has suggestions

Thanks for the reply

Answer 2

You can have a messagebox automatically open when exiting the worksheet with a custom text you could create yourself.

It's just a suggestion :-), here's the VBA code.

Private Sub Worksheet_Deactivate()
MsgBox "your Text"
End Sub