Application.AlertBeforeOverwriting = False 1

[WaterSprite]

I tried to use the Application.AlertBeforeOverwriting = False in a macro, but still got the alert each time when it was time to save. What am I doing wrong?

Sub Macro4()
'
' Macro4 Macro
' Macro recorded 8/16/2006 by warren
'

Application.AlertBeforeOverwriting = False
ChDir "A:\"
ActiveWorkbook.SaveAs Filename:="A:\test.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

thanks for your assistance

 

[Molby]

Try using application.displayalerts instead.