Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charting Macro That deletes Sheet
Sorry about first balnk post
I have and excel macro written that creates a number of different charts for users using dynamic ranges and what type of data they want to chart. The macro deletes the previous chart sheet for them prior to creating the new one, however it always comes up and asks if you want to delete the chart sheet or cancel, is there anyway that I can automate that last single step. -- <<Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charting Macro That deletes Sheet
Hi Dave,
Turn off with:- Application.DisplayAlerts = False Turn back on:- Application.DisplayAlerts = True Ensure that you do turn it back on in the program after the deletion line. Regards, OssieMac "Dave_Tho1968" wrote: Sorry about first balnk post I have and excel macro written that creates a number of different charts for users using dynamic ranges and what type of data they want to chart. The macro deletes the previous chart sheet for them prior to creating the new one, however it always comes up and asks if you want to delete the chart sheet or cancel, is there anyway that I can automate that last single step. -- <<Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charting Macro That deletes Sheet
Application.DisplayAlerts = False
your deletion code Application.DisplayAlerts = True Gord Dibben MS Excel MVP On Fri, 12 Oct 2007 13:26:02 -0700, Dave_Tho1968 wrote: Sorry about first balnk post I have and excel macro written that creates a number of different charts for users using dynamic ranges and what type of data they want to chart. The macro deletes the previous chart sheet for them prior to creating the new one, however it always comes up and asks if you want to delete the chart sheet or cancel, is there anyway that I can automate that last single step. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charting Macro That deletes Sheet
Thanks so much, That saved me alot of issues
-- <<Thanks "OssieMac" wrote: Hi Dave, Turn off with:- Application.DisplayAlerts = False Turn back on:- Application.DisplayAlerts = True Ensure that you do turn it back on in the program after the deletion line. Regards, OssieMac "Dave_Tho1968" wrote: Sorry about first balnk post I have and excel macro written that creates a number of different charts for users using dynamic ranges and what type of data they want to chart. The macro deletes the previous chart sheet for them prior to creating the new one, however it always comes up and asks if you want to delete the chart sheet or cancel, is there anyway that I can automate that last single step. -- <<Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charting Macro, that deletes previous sheet | Excel Discussion (Misc queries) | |||
Macro that deletes rows from cell containing End to end of data. | Excel Discussion (Misc queries) | |||
Macro that deletes every third row....+ | Excel Discussion (Misc queries) | |||
Renaming and saving workbooks but macro still deletes | Excel Worksheet Functions | |||
links from other sheet deletes formulas | Excel Discussion (Misc queries) |