ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to skip save prompt ask me if I want to replace File. (https://www.excelbanter.com/excel-programming/370497-how-skip-save-prompt-ask-me-if-i-want-replace-file.html)

Viviana

How to skip save prompt ask me if I want to replace File.
 
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

Die_Another_Day

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




All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com