Hi, Is possible to disable msg save/replace file confirmation dialogBox by code module? tks.
Hi, Is possible to disable msg save/replace file confirmation dialogBox by code module? tks.
Are you saving by code or manually
Does it happen when you try to save to a filename that already exists?
What steps are you taking and when does the alert occur and what does it say?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I'm sorry , for code I use this :
Option Explicit
Sub DisableSaveAs()
Dim strName As String
strName = ActiveWorkbook.Name
strName = InputBox("Please,....:", , strName)
If strName = "" Then Exit Sub
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs strName
Application.DisplayAlerts = True
End Sub
For real I should like of disabling the message of the manual, but by VBA, is possible?