Answering "Yes" When Saving Over a File

[Ste_Moore01]

Hi everyone,

I've created a macro that does various things on my sheet. At one point, it saves the sheet over an existing file but when it gets to that point it asks me if I want to save over the existing file. Is there some code I can put in my macro which would automatically answer this as yes?

Thanks!

 

[erik.van.geit]

Hi, Ste_Moore01 !
just use

Application.DisplayAlerts = False
'code
Application.DisplayAlerts = True

kind regards,
Erik

 

[Ste_Moore01]

Thanks Erik!

That works perfectly!