Another odd VBA glitch in 2007

T

teepee

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
 
G

Guest

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.
 
T

teepee

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
 
G

Guest

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?
 

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

Run macro on refresh data (pivot table) 0
Format Data Series in a Pivot Chart 2
macro for pivot table 1
remove the border for all series for all charts 8
Looping through charts in a worksheet 1
change in the formatting of data series 2
One Range, Two Colors 4
Debra Dalgleish: Pivot Table problem 3

Top