Nick Hodge
12/13/2006 10:21:00 PM
Jim
Pleasure
--
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk
"Jim" <Jim@discussions.microsoft.com> wrote in message
news:332B8709-0364-45E7-9FBF-5637C4B09334@microsoft.com...
> 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
>> nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
>> www.nickhodge.co.uk
>>
>>
>> "Jim" <Jim@discussions.microsoft.com> wrote in message
>> news:FE0DE8EE-A135-42E1-A664-4E245347E34B@microsoft.com...
>> > 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!
>>