Jim

Application.DisplayAlerts=False

and true at the end

This will take all the defaults in dialogs

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Jim" wrote in message
...
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!