Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Response to Dialog Box
Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True Gord Dibben MS Excel MVP On Wed, 13 Dec 2006 14:09:01 -0800, Jim 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto response of one column to another | Excel Worksheet Functions | |||
Auto Response to Dialog Box | Excel Programming | |||
How to auto response the dialog | Excel Programming | |||
inputbox Auto response | Excel Programming | |||
Macro to Force Response in Dialog Box | Excel Programming |