Try this

Sub macro()
Application.DisplayAlerts = False

"Your code here"

Application.DisplayAlerts = True
End sub