Mega Code Archive

 

Categories / VisualBasic Script / Application

 

If you need to avoid user interaction you can turn off alerts in Excel by setting the DisplayAlerts property of the Applicatio

Sub alert()     Application.DisplayAlerts = False     myWorkbook.Sheets("Summary").Delete     Application.DisplayAlerts = True End Sub