Hi Group,

I try to use macro to create a chart on a new sheet (Daily). I have to
manually delete the chart each time I run the program. If I include the line
Sheets("Daily").Delete
in the program, I will get the prompt each time. Are there any better way to
do this?

Thanks.

Gian

"Gian" wrote in message
...
Hi Group,

I try to use macro to create a chart on a new sheet (Daily). I have to
manually delete the chart each time I run the program. If I include the
line
Sheets("Daily").Delete
in the program, I will get the prompt each time. Are there any better way
to
do this?

Thanks.

Gian

Well, you can try this:
Application.DisplayAlerts = False
....
Application.DisplayAlerts = True

/Fredrik

Thanks Fredrik.

"Fredrik Wahlgren" wrote:


"Gian" wrote in message
...
Hi Group,

I try to use macro to create a chart on a new sheet (Daily). I have to
manually delete the chart each time I run the program. If I include the
line
Sheets("Daily").Delete
in the program, I will get the prompt each time. Are there any better way
to
do this?

Thanks.

Gian

Well, you can try this:
Application.DisplayAlerts = False
....
Application.DisplayAlerts = True

/Fredrik