View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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