delete tab

J

jrh

what code deletes sheet1 without giving the pop up box
confirming you want to delete the tab?

Thank you.
 
P

Peo Sjoblom

Application.DisplayAlerts = False
Worksheets("sheet1").Delete
Application.DisplayAlerts = True
 
R

Ron de Bruin

Try this Jrh

Application.DisplayAlerts = False
Activesheet.Delete
Application.DisplayAlerts = True
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
macOS Office365 Word 0
Word VBA - Delete text from bulleted paragraphs 1
"The operation cannot be performed because the object has been deleted." 0
Vertical short line in front of word 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Word 2016 - Difficulties Learning Style Creation/Application 0

Top