how to over-ride the SAVE AS confirmation in a macro

[alansusans]

I am using macros to run a long and complicated query, I am entering a large number of formulas from the macros, I am using the SAVE AS command to minimise the file size at regular intervals as I copy and paste the results of the formulas inserted with the macros but need to bypass the confirmation window and let the macros keep running. Is there a simple code to add to allow this. Alternatively if there is an option to enable and disable this step in the Options, I have looked but cant see anything, which can be incorporated into a macro.

[mrice]

Try

Application.DisplayAlerts = False

at an appropriate point in your code.

[alansusans]

Thanks for the response, however I still get the request confirmation screen. I have played around where to locate the code but just get compile errors.

[alansusans]

Eventually found where to insert the code, was inserting it too late. It works fine. Many thanks.