How to stop prompts while running vba

[SebastianHuang]

I get this message when running the delete current sheet warning, is there a way to disable it?
Sub DeleteActiveSheet()

ActiveSheet.Delete
'OR You can mention the Sheet name



End Sub

Also, is there a code so that I can delete grouped sheets as well instead of the just the active sheeet?
Thanks.

 

[SebastianHuang]

Application.DisplayAlerts = False Solved it.

 

[Jon Peltier]

Don't forget

Application.DisplayAlerts = True

after you delete the sheet.

 

[SebastianHuang]

Don't forget

Application.DisplayAlerts = True

after you delete the sheet.

Well. It was only one command in the module and I didn't have anything else in there. is there a reason to turn it back on in that situation?

 

[Jon Peltier]

I always do, because I'm never sure that it automatically resets when the VBA procedure exits.