Hi,

Lookin to delete sheets in the Excel.Workbook without the user being prompted fro EVERY sheet I delete in code.

ie..

VB Code:
  1. Dim sheet As Excel.Worksheet
  2.     Set sheet = New Excel.Worksheet
  3.     sheet.Delete ' <-- This always prompts the user!! ARGH!

Dave