Thread: deleting sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Black Robert Black is offline
external usenet poster
 
Posts: 4
Default deleting sheets

Add this before the statement that deletes

application.displayalerts = false

then before your macro quits

application.displayalerts = True


"david" wrote in message
...
When I delete a sheet in a workbook with a macro it always
has a pop-up that asks if I really want to delete that
sheet. How do I get the macro to tell it yes for me?

Thanks,
David