In Excel 2003 - how do you switch off the "Confirm Delete" functi.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to switch off the confirm delete dialogue in Excel 2003
which results in a "Confirm Block delete Yes/No ?" dialogue. I am
highlighting text in a table and this is an annoying unnecessary check.
 
Sub DeleteSheet(strSheetName As String)
' deletes a sheet named strSheetName in the active workbook
Application.DisplayAlerts = False
Sheets(strSheetName).Delete
Application.DisplayAlerts = True
End Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top