Problem where lines are always reverting to white

  • Thread starter Thread starter frizzo500
  • Start date Start date
F

frizzo500

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?
 
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 = 10 Then
Selection.ShapeRange.Line.ForeColor.SchemeColor = 12
Else
Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
End If
Exit Sub

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

Regards,

Valentín
***************************************************************************
(e-mail address removed) ha escrito:
 
Back
Top