PDA

View Full Version : Disable msg SaveAs



Felipe Dasi
04-17-2008, 12:17 PM
Hi, Is possible to disable msg save/replace file confirmation dialogBox by code module? tks.:banghead:

lucas
04-17-2008, 12:29 PM
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?

Felipe Dasi
04-18-2008, 02:59 AM
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?