Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Chart
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Chart
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Chart
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart formatting and chart templates in Excel 2007 | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
vc++ automation: opening chart as chart window and setting scale | Excel Programming |