Stopping Excel's Warning Prompts for Recorded Macros : Application.DisplayAlerts « Application « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Application
3. Application.DisplayAlerts

Stopping Excel's Warning Prompts for Recorded Macros

 

Sub MyMacro( )
      Application.DisplayAlerts = False
      ActiveSheet.Delete
      Application.DisplayAlerts = True
End Sub

 

Related examples in the same category