Results 1 to 2 of 2

Thread: How to disable alert message on save ?

  1. #1

    How to disable alert message on save ?



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

    Thanks for helpers

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •