| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto response of one column to another | Excel Worksheet Functions | |||
| Response to Frank: AM-PM Auto formatting | Excel Discussion (Misc queries) | |||
| How to auto response the dialog | Excel Programming | |||
| inputbox Auto response | Excel Programming | |||
| Macro to Force Response in Dialog Box | Excel Programming | |||
Linear Mode
