Macro help - "Save As" when a file already exists

[Guest]

I am using a macro to populate an existing file and then password protect the
file. Since the file already exists, I get the do you want to save over the
existing file message. I do want to save over the existing file. When I
recorded the macro, it does not include the response to the save over the
existing file question. Is there code to make the macro save over the
existing file?

Thanks

 

[Ron de Bruin]

You can use this Dave

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