Auto Response to Dialog Box
 

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!

Auto Response to Dialog Box
 

Jim

Pleasure

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


"Jim" wrote in message
...
Nick -

OUTSTANDING! Worked like a charm. Thanks so much!

Jim
--
Thanks for all you do!


"Nick Hodge" wrote:

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!