With the following code 2007 will change the colours but won't change the
border lines
In fact it takes out all the border lines that were already there.
Anyone know a workaround?

ActiveChart.SeriesCollection(2).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
With Selection.Interior
.ColorIndex = 38
.Pattern = xlSolid

No workaround to offer, but we can give all of these a name?
YACAGG: Yet Another Carting and Graphic Glitch ??

They seem to be piling up.

"teepee" wrote:

> With the following code 2007 will change the colours but won't change the
> border lines
> In fact it takes out all the border lines that were already there.
> Anyone know a workaround?
>
> ActiveChart.SeriesCollection(2).Select
> With Selection.Border
> .Weight = xlThin
> .LineStyle = xlAutomatic
> End With
> Selection.Shadow = False
> With Selection.Interior
> .ColorIndex = 38
> .Pattern = xlSolid
>
>
>

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis)> wrote in message
newsF7120C9-9BF9-4925-B412-(E-Mail Removed)...
No workaround to offer, but we can give all of these a name?
YACAGG: Yet Another Carting and Graphic Glitch ??

They seem to be piling up.

Oh well I expect they'll fix them as they get round to it

I understand they're collecting these little jewels and that SP1 is already
in the works - but I would not expect to see it until late this year?

"teepee" wrote:

>
> "JLatham" <HelpFrom @ Jlathamsite.com.(removethis)> wrote in message
> newsF7120C9-9BF9-4925-B412-(E-Mail Removed)...
> No workaround to offer, but we can give all of these a name?
> YACAGG: Yet Another Carting and Graphic Glitch ??
>
> They seem to be piling up.
>
> Oh well I expect they'll fix them as they get round to it
>
>
>

I wish they'd fix the VBA password facilty so it wasn't so easy to crack.