How to disable alert message on save ?

xynet · Sep 12, 2014

Hello I receive alert when trying to save my CSV file and was wondering how to disable it ?

Thanks for helpers

WizzardOfOz · Sep 18, 2014

You could use a small macro (see below). The problem comes in that a CSV can not run a macro. You can bypass this by including the macro as part of your personal macros or an Excel add in.

Code:

Sub SaveNoAlerts()
      Application.DisplayAlerts = False
      ActiveWorkbook.Save
      Application.DisplayAlerts = True
End Sub

How to disable alert message on save ?

xynet

New member

WizzardOfOz

New member