New Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...

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

/Fredrik
 
Thanks Fredrik.

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

/Fredrik
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
Help: Chart & data 1
Excel 2010. How to copy chart format to all charts in sheet 2
Dynamic Chart ranges 6
Delete chart without being prompted? 2
How do I automatically create lists from column topics in a chart 0
Macro to determine chart name 5
I need to give index number to charts 3

Back
Top