Using Macro to Delete a tab in a file

[Guest]

I would like to use a macro to delete a tab in a workbook. When I execute
the macro, I get the message asking if it is ok to delete the sheet. Is
there a way to have the macro answer the question "yes".

Thanks

 

[Frank Kabel]

Hi
add the line
application.displayalerts=false
before the delete statement and afterwards add:
application.displayalerts=true

 

[Ray Costanzo [MVP]]

Application.DisplayAlerts = False
''your code to delete worksheet here

Ray at work