Gord Dibben
12/13/2006 10:46:00 PM
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
Gord Dibben MS Excel MVP
On Wed, 13 Dec 2006 14:09:01 -0800, Jim <Jim@discussions.microsoft.com> 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!