Code:
Application.DisplayAlerts = False
'  Do what you need here...
Application.DisplayAlerts = True