To remove the promt question message in a Save As method

  • Thread starter Thread starter sharpegreg
  • Start date Start date
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
 
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...........
Application.DisplayAlerts = True

If this post helps click Yes
 
Back
Top