Yes it is in the same workbook and is
Sub Sort()
'sorting code
End Sub

However when I close the workbook all that happens... AH now I think I
know why.

I don't have code that saves the workbook after it runs the code.