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 |
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 |
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 |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com