View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_37_] Bob[_37_] is offline
external usenet poster
 
Posts: 1
Default Excel Reports Wrong Border Color

In VBA, this code

ActiveCell.Borders(xlEdgeBottom).Color

returns the original pallette color rather than the custom
color the user set that pallette color to be. The
spreadsheet displays the desired custom border color but
the code returns only the original color.

Saving/closing the workbook/Excel does not affect the
problem.

How do you get the actual displayed color of a border
line? BTW, the environment is XL97.

Tx