Application VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Application
  4. 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