Hi,

i wrote code in xl07 and saved as 97-2003. i tried to open workbook in xl03 but code does not work (no effect)
"#N/D" labels are not whitened.

rgs

U¿ytkownik "Andy Pope" napisa³ w wiadomo¶ci ...
Hi,

The code works in xl03 if the workbook is saved as 97-03 compatible.
Add a break point on the first line and step through the code to see if all
the lines are executed as expected.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"God Itself" wrote in message
...
Hi,

i have sheet's code which works perfecly in Excel 2007, but nothing happens
in excel 2003. No error occurs. what may be the cause?

Private Sub Worksheet_Calculate()'white label when value = NA()

With Workbooks("chart").Sheets("tmp").Shapes("Wykres
1").DrawingObject.Chart
For i = 1 To 7
.SeriesCollection(1).Points(i).DataLabel.Font.Colo rIndex = 0
Next i
For i = 1 To 7
If .SeriesCollection(1).Points(i).DataLabel.Text = "#N/D!" Then
.SeriesCollection(1).Points(i).DataLabel.Font.Colo rIndex = 2
End If
Next i
End With

End Sub

regards