Thread: To remove the promt question message in a Save As method
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default To remove the promt question message in a Save As method
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...........
Application.DisplayAlerts = True

If this post helps click Yes
---------------
Jacob Skaria


"sharpegreg" wrote:

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
Reply With QuoteReply With Quote