View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kurt Kurt is offline
external usenet poster
 
Posts: 47
Default How can I delete multiple sheets in VBA...

Greetings All,

How can I delete multiple sheets in VBA without having to acknowledge the
Excel warning message for each sheet?

I wrote a VBA routine that would loop through and delete all but the first
sheet.
But I have to acknowledge the warning message for each shett.

Is there a way to select a range of sheets for deletion and only have to
acknowledge the deletion once OR can I supress the warning message?

Thanks in advance!!!