ExcelBanter - Disable excel message

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Disable excel message (https://www.excelbanter.com/excel-programming/366157-disable-excel-message.html)

Jaylin

Disable excel message

May I know what is the code to disable the following excel message:-

"Do you want to replace the contents of the destination cells?"
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Stefi

Disable excel message

Try
Application.DisplayAlerts = False
It is recommended to reset it just after it did its job:
Application.DisplayAlerts = True
Regards,
Stefi

€žJaylin€ ezt Ã*rta:

May I know what is the code to disable the following excel message:-

"Do you want to replace the contents of the destination cells?"
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

All times are GMT +1. The time now is 05:15 PM.