View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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*******