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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert OST to PDF? Simple Methods 4
How to convert a .msg File? 2
How To Exit Macro Without Debug Prompting 4
Can we Set Default value for the Excel promt(Y/N) 2
Change default Save As file type 2
HOW TO EMAIL FILE LINK BY MACRO 1
Save as, not overwrite 1
macro to save file as 4

Back
Top