To remove the promt question message in a Save As method

S

sharpegreg

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg
 
J

Jacob Skaria

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...........
Application.DisplayAlerts = True

If this post helps click Yes
 
Top