Problem where lines are always reverting to white

[[email protected]]

Hi. I am having a problem in Excel where every drawing toolbar line in
my document is displayed as white, making them non viewable. When I
double click on the line to change the color to black (or any other
color), it changes the line color in the worksheet, but only
temporarily (when I save, close and reopen it's gone). I noticed when
I try changing the line color, it never really updates in the "format
auto shape" window "color" field. It only displays white. I am on
Microsoft Office Profession 2003 and have loaded all updates available
and have tried reinstalling from scratch, but the problem still exists.
The drawing lines in Word work fine. Has anyone experienced a similar
problem and have any suggestions to correct?

[Valentín]

It's not easy to work with shapes in Excel VBA. I found problems trying
to select a shape from a collection.

I have tried this code:

ActiveSheet.Shapes("Line 1").Select
If Selection.ShapeRange.Line.ForeColor.SchemeColor =3D 10 Then
Selection.ShapeRange.Line.ForeColor.SchemeColor =3D 12
Else
Selection.ShapeRange.Line.ForeColor.SchemeColor =3D 10
End If
Exit Sub

It works and keeps the color having only one line in the sheet.

Regards,

Valent=EDn
***************************************************************************
[email protected] ha escrito:

> Hi. I am having a problem in Excel where every drawing toolbar line in
> my document is displayed as white, making them non viewable. When I
> double click on the line to change the color to black (or any other
> color), it changes the line color in the worksheet, but only
> temporarily (when I save, close and reopen it's gone). I noticed when
> I try changing the line color, it never really updates in the "format
> auto shape" window "color" field. It only displays white. I am on
> Microsoft Office Profession 2003 and have loaded all updates available
> and have tried reinstalling from scratch, but the problem still exists.
> The drawing lines in Word work fine. Has anyone experienced a similar
> problem and have any suggestions to correct?