Hi Frank,

The excel will set Application.DisplayAlerts to "true" as default as the
macro running was done.

Is it possible to set this default value as "false"?

I think that you will need to set DisplayAlerts to False wherever you need
to do so. The setting is not persistent.

---
Regards,
Norman



"FrankJIN" wrote in message
...
The excel will set Application.DisplayAlerts to "true" as default as the
macro running was done.

Is it possible to set this default value as "false"?

Thanks.