Surround your code with Display Alerts like following..Application.DisplayAlerts = FalseWorksheets("Sheet1").DeleteApplication.DisplayAlerts = True