delete sheet

  • Thread starter Thread starter Esau
  • Start date Start date
E

Esau

how can i write this without answering yes or no


Sub deleteSheet()
'
Application.DialogBox = False
ActiveWindow.SelectedSheets.Delete
Application.DialogBox = True

End Sub

Would like Thank You
 
Sub deleteSheet()
'
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

End Sub
 
You must log in or register to reply here.

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

Similar Threads

Application.EnableEvents = False not working 2
Error Trapping Question 8
Delete Worksheets 4
how to remove selected sheet from CommandBarComboBox 3
Delet Sheets with out Automation Error 5
Suppress Delete Sheet Warning 1
The best way to build your own VBA library 2
Copy worksheet from one workbook to another 3

Back
Top