Suppress the "Saving" message when saving an excel file

[jdhfch]

Good morning,

I have a workbook on a shared drive that saves automatically. I am trying to suppress the "Saving" pop up box when it does save. Can anyone help, please?

 

[zero269]

Good morning,

I have a workbook on a shared drive that saves automatically. I am trying to suppress the "Saving" pop up box when it does save. Can anyone help, please?

I haven't tested this, but according to Microsoft, you can save without prompts using the following vba code:

Sub Auto_Close()
    ThisWorkbook.Saved = True
End Sub

"How to suppress Save Changes" prompt when you close a workbook in Excel - Microsoft Support

support.microsoft.com

There's more discussions about this on this thread; same question: VBA code to save workbook with no prompt

 

[maxpit]

Hi jdhfch,

if you want to save a file without the message appearing, you should use Application.SisplayAlerts as shown below

    [...] ' Your code here

    Application.DisplayAlerts = False
   
    ThisWorkbook.SaveAs sFilename  ' Save your Workbook and if you want you can add other parameters
   
    Application.DisplayAlerts = True

    [...] ' Other your code here

Bye