Add the following statement before you start processing your files:

Application.DisplayAlerts = False

Although your alerts will come back on after the macro finishes running I
always add the following line at the end of the macro:

Application.DisplayAlerts = True

It keeps it tidy and who knows if it will become mandatory in some later
release of Excel.
--
Kevin Backmann


"Francesco Magagnino" wrote:

Hello,
i use a macro to divide an excel file in many files, and create and
delete some sheet.
This run many times.
All the times a file is saved overwriting an existing one i ask me
what to do; the same when the command say to delete a sheet.

there is a way to avoid this.
i need to run the macro and leave the pc make everything without
anybody present

thanks
franz