Deleting Excel Sheets without User intervention

Hey!

I am writing a macro that uses one sheet as an output sheet. If I run this macro, it clears the existing output, kills all sheets except the first one (which contains the macro;)) and creates it from the draft.

The thing is, the people I work for would flip if they see the macro deleting anything , even what the very same macro created. So I don't want the user to be asked if there is a sheet to be deleted. I just want to kick it, and it's my right, I created it :D

VB Code:

Excel.Application.DisplayAlerts = False

Make sure you set it back to true at the end of your procedure, or there'll be tears...

:D :D

Thanks, Duncan!