Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to sidestep popups...
Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want to delete the relevant sheet. This brings the whole macro to a halt. Is there a command I can use to avoid the popup , and have the macro perform the deletion without stopping the whole routine? Grateful for any help. Best Wishes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to sidestep popups...
Application.displayalerts = false
'your code here application.displayalerts = true Colin Hayes wrote: Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want to delete the relevant sheet. This brings the whole macro to a halt. Is there a command I can use to avoid the popup , and have the macro perform the deletion without stopping the whole routine? Grateful for any help. Best Wishes -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to sidestep popups...
Try it this way...
Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True -- Rick (MVP - Excel) "Colin Hayes" wrote in message ... Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want to delete the relevant sheet. This brings the whole macro to a halt. Is there a command I can use to avoid the popup , and have the macro perform the deletion without stopping the whole routine? Grateful for any help. Best Wishes |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to sidestep popups...
application.dispayalerts = false
ActiveWindow.SelectedSheets.Delete application.displayalerts = true -- HTH... Jim Thomlinson "Colin Hayes" wrote: Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want to delete the relevant sheet. This brings the whole macro to a halt. Is there a command I can use to avoid the popup , and have the macro perform the deletion without stopping the whole routine? Grateful for any help. Best Wishes . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to sidestep popups...
In article , Rick Rothstein
writes Try it this way... Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True Hi All OK Thanks for the suggestions - that's fixed it. No more popup. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Popups to supply variables | Excel Worksheet Functions | |||
Customising Standard Popups | Excel Discussion (Misc queries) | |||
Amending standard Excel popups | Excel Worksheet Functions | |||
Disabling security popups | Excel Worksheet Functions | |||
Automated Popups | Excel Worksheet Functions |