Auto Response to Dialog Box
 

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 14:09:01 -0800, Jim wrote:

I've created a macro that deletes several tabs from a workbook. When the
macro is run, a dialog box displays - "Data may exist in the sheet(s)
selected for deletion. To permanently delete the data, press Delete."

Is there any coding I can add to the macro that will auto-select 'Delete'
without prompting the user?

Thanks for all your help!