Test if a user defined chart name is valid

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

I am changing chart type by macro. Is there a way to test if a user
defined chart name is valid? Excel 2000 & 2007
 
I am changing chart type by macro. Is there a way to test if a user
defined chart name is valid?    Excel 2000 & 2007
Click to expand...

you can use something like this:

For n = 1 To 20
On Error GoTo 987687
Chartnames(n) = ActiveSheet.ChartObjects(n).Name
987687
Next n

does this help ?
 
I should have said template name like in excel 2007
In Windows 98 excel 2000, they are stored here.
"c:\Program Files\Microsoft Office\Office\XLUSRGAL.XLS"

I am looking for a validity test before applying user defined charts
to an existing chart by macro.
 
Please indicate step by step what you would like top do, because this
is not making too much sense.

sorry
 

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

Excel 2007 Charts & Memory Leak?? 7
excel 2007 errors on chart changes 1
Why do charts disappear? 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Protect worksheet cells but still allow macro to edit chartproperties 2
Embedded Chart protection 1
VBA Chart Size Accuracy 1
xlusrgal.xls in excel 2007 2

Back
Top