Auto close 'overwrite existing data' box

I am very new to excel's macros and vba coding...

I've made my first macro to run 16 regressions, but 16 times I get the warning box for overwriting existing data, so I have to click OK button 16 times in a row and it annoys me.

Application.DisplayAlerts = False
I tried this solution, put it everywhere in the script but it doesn't help.

Any ideas?

Thanks!

You just place Application.DisplayAlerts = False before the process is invoked and don't forget to set it back to true after the proces is completed
Without a sample of what you're doing that's all I can say

@papaj: not much use without the workbook it refers to !!!

Toen i suggestie you take a look at the file you attached

This is the macro named Regression in your attached file:

Sub Regression()

     Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$A$2:$A$5"), _
        ActiveSheet.Range("$B$2:$C$5"), False, False, , ActiveSheet.Range("$A$7") _
        , False, False, False, False, , False
     Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$D$2:$D$5"), _
        ActiveSheet.Range("$E$2:$F$5"), False, False, , ActiveSheet.Range("$A$29") _
        , False, False, False, False, , False
        
End Sub

I suggest you explain this: "ATPVBAEN.XLAM!Regress"