Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Confirm Deleting Charts
Hi All,
I'd like to clean all the created charts after analysis, so I record a macro to delete the charts one by one. The problem is: there will always popup a msg box asking me to confirm deleting the charts. Is there a way to disable the confirming deleting msg? Thanks in advance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Confirm Deleting Charts
Hi
try application.displayalerts=false 'your deletion code application.displayalerts=true -----Original Message----- Hi All, I'd like to clean all the created charts after analysis, so I record a macro to delete the charts one by one. The problem is: there will always popup a msg box asking me to confirm deleting the charts. Is there a way to disable the confirming deleting msg? Thanks in advance! --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Confirm Deleting Charts
fatfish wrote:
Hi All, I'd like to clean all the created charts after analysis, so I record a macro to delete the charts one by one. The problem is: there will always popup a msg box asking me to confirm deleting the charts. Is there a way to disable the confirming deleting msg? Thanks in advance! Put this at the start of *every* macro you record: With Application .Calculation = xlManual .ScreenUpdating = False .DisplayAlerts = False End With And this at the end: With Application .Calculation = xlAutomatic .ScreenUpdating = True .DisplayAlerts = True End With It's the DisplayAlerts stuff that will solve your problem. PS: Please don't thank people in advance. It's more polite (and more motivating) to thank them afterwards. -- Amedee Van Gasse To top-post is human, to bottom-post and snip is sublime. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Confirm Deleting Charts
Hi Frank & Amedee,
Thanks! Both of them works very well!! Amedee's code also disable the screenupdating, which makes the macro "cleaner"! ;) and thanks for your suggestion of "No thanks in advance" ! :P Best Regards, Fatfis -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Confirm Deleting Charts
fatfish wrote:
Hi Frank & Amedee, Thanks! Both of them works very well!! Amedee's code also disable the screenupdating, which makes the macro "cleaner"! ;) and thanks for your suggestion of "No thanks in advance" ! :P Best Regards, Fatfish --- Message posted from http://www.ExcelForum.com/ Thank you for thanking me. Now nothing can spoil my day! :) -- Amedee Van Gasse To top-post is human, to bottom-post and snip is sublime. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting rid of the "confirm delete" dialogue box when deleting a s | Excel Discussion (Misc queries) | |||
Automatically deleting macros | New Users to Excel | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Confirm before deleting a worksheet? | Excel Discussion (Misc queries) | |||
Deleting charts on a sheet | Excel Programming |