MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting a sheet without that annoying popup


Posted by doug on January 24, 2001 1:05 PM

Currently the code i'm using to delete a sheet is
Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.delete
however a popup is shown asking if i am sure. Is there any way to make the
popup not show up?


Posted by Faster on January 24, 2001 1:26 PM

Sub FromWeb()
'delete current sheet without warnings
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
End Sub

Posted by Celia on January 24, 2001 5:48 PM


Should also set Application.DisplayAlerts back to True after deleting the sheets.