remove the border for all series for all charts
Attempting to remove the border for all series for all charts in my
spreadsheet. can this be modified? if so, pelase suggest how?
thanks
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 4/9/2007 by b0467256
'
'
ActiveSheet.ChartObjects("Chart 10").Activate
ActiveChart.SeriesCollection(8).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlNone
End With
Selection.Shadow = False
Selection.InvertIfNegative = False
Selection.Interior.ColorIndex = xlAutomatic
End Sub
|