After changing the color of the borders under FormatCellsBordersColor make
sure you have FilePage setupSheet set for printing in color, not "black and
white".


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow"
wrote:



"Bob Phillips" wrote:

ToolsOptionsView and change the colour in the Color dropdown.

OOPS! I should have said: "Change the color of the 'printed' cell borders",
not the grid lines that show on the screen. I expected to be able to change
the color/type of the cell border lines under FormatCellsBorders, but that
doesn't seem to work (as I would have expected it to).
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tourkow" wrote in message
...
When I use the "Cell Border" button on the toolbar to put borders around
selected cells, is there a way I can change the color/type of the border
lines (for the whole worksheet)?