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?
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.