Thread: How to skip save prompt ask me if I want to replace File.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default How to skip save prompt ask me if I want to replace File.
I'm not certain this will work, but try:
Application.DisplayAlerts = False
'Code to Save
Application.DisplayAlerts = True

Charles
Viviana wrote:
Hi,

Can can anyone please advise me how to default my setting to replace file
when I want to save the same file under the same folder.

This pop up is driving me crazy. Is there way that I can get rid of this pop
up?

Thank you

Reply With QuoteReply With Quote