Hi,
Lookin to delete sheets in the Excel.Workbook without the user being prompted fro EVERY sheet I delete in code.
ie..
VB Code:
Dim sheet As Excel.Worksheet Set sheet = New Excel.Worksheet sheet.Delete ' <-- This always prompts the user!! ARGH!
Dave




Reply With Quote