Have you tried this:

Application.DisplayAlerts = False

>I've written an Excel 97 template for a client (they insisted on doing it this way ...) in which I read in a flat file and create a number of tabs and populate them.
>
>I also give the user the ability to re-import the file and overwrite their exisiting data if necessary. When I go and delete each spreadsheet tab with this code:
>
>

>
>Do While i <= Sheets.Count
>    If Left(Sheets(i).Name, 8) = "Property" Then
>        Sheets(i).Delete
>    Else
>        i = i + 1
>    End If
>Loop
>
>

>
>For each tab that it deletes the user has to click OK to a warning message - in some cases this is over 20 times! I'd like the code to just delete the tabs without the user prompt.
>
>I've tried
>
>

>
>Application.Interactive = False
>
>

>
>... but that doesn't seem to do the trick. Does anyone know which, if any, property I can tweak so that the user isn't prompted to confirm each tab delete?