Not having to answer "Do you want to overwrite" question

[Mackeral]

I have a lot workkbooks that I always want to overwrite. Is there any way create a macro to do that without being asked if I "want to overwrite?

Mac





Why?

 

[cadandcode]

Application.DisplayAlerts = False

 

[zero269]

Is there any way create a macro to do that without being asked if I "want to overwrite?

Hi Mac,
cadandcode provided the code at the beginning of your vba code being used to overwrite a workbook without being prompted.

Application.DisplayAlerts = False

However, I learned recently that it's recommended to re-enable the DisplayAlert at the end of your code so it's not off All of the time using:

Application.DisplayAlerts = True

Be sure to test on a TEST file...