VBA Close Pop Up

[Valery_Paris]

Dear Community

I use the following code

Sheets("Temp").Select
ActiveWindow.SelectedSheets.Delete

At this stage a pop up asks the user to confirm the deletion.

I intend to by pass this request or at least automatically validate the deletion in a delay of one second

Could you please help to code it ?

Best Regards

[cubangt]

Do this around the deletion


Application.DisplayAlerts = False 'switching off the alert button

ActiveSheet.Delete

Application.DisplayAlerts = True 'switching on the alert button