How can I disable system alerts (deleting a sheet for example)?
Sub SheetDelete()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub
Assign to a button or shortcut key-combo.
Gord Dibben Excel MVP
On Fri, 16 Dec 2005 05:37:03 -0800, "andriil"
wrote:
Every time delete a sheet, I get a system alert saying "Data may exist in the
sheet(s) selected for deletion. To permanently delete the data, press
Delete". It's a bit annoying when you have to delete many sheets and you
don't want to select multiple sheets. Is there any possibility to disable
this alert?
|