Application.DisplayAlerts (Excel)

True if Microsoft Excel displays certain alerts and messages while a macro is running.

The default value is True. Set this property to False to suppress prompts and alert messages while a macro is running; when a message requires a response, Microsoft Excel chooses the default response. If you set this property to False, Excel sets this property to True when the code is finished, unless you are running cross-process code.

Application.DisplayAlerts = True