Display Alerts Property of Application Object

  • If the user enables this property while exectuting the program application doesn't return any alerts
  • Click on below mentioned image to watch video:

    •  

    Download the Workbook

     

    Sub DisplayAlertsPropertyOf_Application_Object()
    Application.DisplayAlerts = False

    Dim Wkb As Workbook
    Set Wkb = ActiveWorkbook
    Wkb.Sheets("Sheet4").Delete

    Application.DisplayAlerts = True
    End Sub

     

Hi Welcome to VBA Tutorial.