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

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

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.

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