Do While i <= Sheets.Count If Left(Sheets(i).Name, 8) = "Property" Then Sheets(i).Delete Else i = i + 1 End If LoopFor 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.
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?