PDA

View Full Version : Solved: Suppressing a message box



infinity
08-11-2007, 08:36 PM
Hey VBaxers,

I have got code that saves my workbook to an external hard drive as a backup. Everytime I run this code I get a ballon that says this "file already exists, do you want to replace it?" Is there any way of suppressing this message only when I run this code? I will always want to replace the file and would rather not have to tell it "Yes" everytime. Thanx, ya'all!

Scott

shasur
08-11-2007, 08:56 PM
' Do not Show the Alerts from Excel

Application.DisplayAlerts = False

'' do your saving here

'Now reset
Application.DisplayAlerts = True

infinity
08-12-2007, 06:25 PM
shasur,

Thank you, thank you! :thumb I knew there was a simple way of doing it and I thought I had done it before with a different workbook but I could not find it. Thanx again.