Hi,
Have 2 queries regarding this matter:
(Am using Excel 97)
1. Is it possible to assign charts a name(ie instead of bing called "Chart1" in VB, i'd like to call it something else.) I have noticed that an individual chart does not have any properties. It seems that only a chart sheet, or a work sheet has properties. is that becasue charts are not stored as objects in excel??
2. I have a worksheet with 36 charts in it. i would like to be able to select any combination of these charts and print them, without having to click on them individually. is this at all possible, as i have noticed that performing a "ctrl + select" does not select the individual chart.
Your help would me most appreciated!
Thanx in advance!
ABASU
Have 2 queries regarding this matter:
(Am using Excel 97)
1. Is it possible to assign charts a name(ie instead of bing called "Chart1" in VB, i'd like to call it something else.) I have noticed that an individual chart does not have any properties. It seems that only a chart sheet, or a work sheet has properties. is that becasue charts are not stored as objects in excel??
2. I have a worksheet with 36 charts in it. i would like to be able to select any combination of these charts and print them, without having to click on them individually. is this at all possible, as i have noticed that performing a "ctrl + select" does not select the individual chart.
Your help would me most appreciated!
Thanx in advance!
ABASU