View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Another odd VBA glitch in 2007

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