| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Sheets - Without a prompt
Anyone know if its possible to switch off prompting for confirmation when a
macro wants to delete a sheet ? I've tried using sendkeys with " " to click the default button but that doesn't seem to work. Thanks, Nick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting Sheets - Without a prompt
Give this a whirl...
Application.DisplayAlerts = False Sheets("Sheet1").Delete Application.DisplayAlerts = true -- HTH... Jim Thomlinson "Nicholas B" wrote: Anyone know if its possible to switch off prompting for confirmation when a macro wants to delete a sheet ? I've tried using sendkeys with " " to click the default button but that doesn't seem to work. Thanks, Nick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting Sheets - Without a prompt
Thanks Jim
How simple ! "Jim Thomlinson" wrote: Give this a whirl... Application.DisplayAlerts = False Sheets("Sheet1").Delete Application.DisplayAlerts = true -- HTH... Jim Thomlinson "Nicholas B" wrote: Anyone know if its possible to switch off prompting for confirmation when a macro wants to delete a sheet ? I've tried using sendkeys with " " to click the default button but that doesn't seem to work. Thanks, Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make excel not prompt before deleting worksheets? | Excel Worksheet Functions | |||
| How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions | |||
| Prompt before deleting worksheets? | Excel Discussion (Misc queries) | |||
| Deleting sheets removing/turning off the xl prompt | Excel Programming | |||
| Deleting a Prompt Message | Excel Programming | |||
![Nicholas B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
