You could make a sort macro and at the beginning of the macro write:
Application.DisplayAlerts = False
and at the end of the macro before the End Sub write:
Application.DisplayAlerts = True

Swisse