Using Macro to Delete a tab in a file
Hi
add the line
application.displayalerts=false
before the delete statement and afterwards add:
application.displayalerts=true
--
Regards
Frank Kabel
Frankfurt, Germany
Dave wrote:
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
|