That's what I was looking for. Thanks Eric.

>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?