Re: Auto Response to Dialog Box

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Nick Hodge" <nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx>
Date: Wed, 13 Dec 2006 22:12:07 -0000

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@xxxxxxxxxxxxxxxx
www.nickhodge.co.uk

"Jim" <Jim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FE0DE8EE-A135-42E1-A664-4E245347E34B@xxxxxxxxxxxxxxxx

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 ***(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!

Prev by Date: Re: File attributes
Next by Date: Workbook reopens after close
Previous by thread: Inputbox Location on Screen. Can you code it to popup lower on the screen ?
Next by thread: Re: Auto Response to Dialog Box
Index(es):
- Date
- Thread