| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting rid of the "confirm delete" dialogue box when deleting a s
I have a workbook with thousands of sheets and want to use a macro to delete
selected sheets. Problem is the macro is stopped to "The selected sheet will be permanently deleted, please confirm delete.............". Can this dialogue box be turned off permanently? thanks Bernard. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting rid of the "confirm delete" dialogue box when deleting a s
application.displayalerts=false code reset to true -- Don Guillett Microsoft MVP Excel SalesAid Software "Bernard" wrote in message ... I have a workbook with thousands of sheets and want to use a macro to delete selected sheets. Problem is the macro is stopped to "The selected sheet will be permanently deleted, please confirm delete.............". Can this dialogue box be turned off permanently? thanks Bernard. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting rid of the "confirm delete" dialogue box when deleting a s
Hi,
I generally recommend you bracket the command that will cause the message to display as follows Application.DisplayAlert = False ' the delete sheet line Application.DisplayAlert = False the reason is that this suppresses most alert until the subroutine is complete and if there are any other parts of your code that would generate an alert if something was wrong you would not see it. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Bernard" wrote: I have a workbook with thousands of sheets and want to use a macro to delete selected sheets. Problem is the macro is stopped to "The selected sheet will be permanently deleted, please confirm delete.............". Can this dialogue box be turned off permanently? thanks Bernard. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting rid of the "confirm delete" dialogue box when deleting
Thanks for that. However it responds with "Run time Error '438'
Object doesn't support this property or method" I am using Excel 2000. Bernard. "Shane Devenshire" wrote: Hi, I generally recommend you bracket the command that will cause the message to display as follows Application.DisplayAlert = False ' the delete sheet line Application.DisplayAlert = False the reason is that this suppresses most alert until the subroutine is complete and if there are any other parts of your code that would generate an alert if something was wrong you would not see it. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Bernard" wrote: I have a workbook with thousands of sheets and want to use a macro to delete selected sheets. Problem is the macro is stopped to "The selected sheet will be permanently deleted, please confirm delete.............". Can this dialogue box be turned off permanently? thanks Bernard. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting rid of the "confirm delete" dialogue box when deleting
Shane missed the syntax. Note the "s"
Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True Gord Dibben MS Excel MVP On Thu, 2 Jul 2009 23:42:01 -0700, Bernard wrote: Thanks for that. However it responds with "Run time Error '438' Object doesn't support this property or method" I am using Excel 2000. Bernard. "Shane Devenshire" wrote: Hi, I generally recommend you bracket the command that will cause the message to display as follows Application.DisplayAlert = False ' the delete sheet line Application.DisplayAlert = False the reason is that this suppresses most alert until the subroutine is complete and if there are any other parts of your code that would generate an alert if something was wrong you would not see it. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Bernard" wrote: I have a workbook with thousands of sheets and want to use a macro to delete selected sheets. Problem is the macro is stopped to "The selected sheet will be permanently deleted, please confirm delete.............". Can this dialogue box be turned off permanently? thanks Bernard. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| cancel the "Getting Started" Dialogue Box when I open XL/Word | Setting up and Configuration of Excel | |||
| "Save In" dialog (dialogue) issue | Excel Discussion (Misc queries) | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
Hybrid Mode
