View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Automatically Confirm Deleting Charts

Hi
try

application.displayalerts=false
'your deletion code
application.displayalerts=true

-----Original Message-----
Hi All,

I'd like to clean all the created charts after analysis,
so I record a macro to delete the charts one by one.

The problem is: there will always popup a msg box asking
me to confirm deleting the charts.

Is there a way to disable the confirming deleting msg?

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

.