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?