BorderAround settng wrong color

[Warship]

So I have a WB originally written in Excel2010.
On the same box with Excel 2007, BorderAround has lost it's mind in this WB.
At the moment I no longer have 2010 on this box to retry it there.

This code actually produces a border in blue RGB(0, 0, 238).

Selection.BorderAround Color:=RGB(255, 0, 0), Weight:=xlThick

Seems to be this behavior is only in the existing WB.
Newly added sheets to the same WB have the same behavior as well.

However newly added WB's do not.

Also regardless of how I code the color red - vbRed, -16776961, RGB(255, 0, 0) - all produce the blue RGB(0, 0, 238).
But only when using BorderAround.

Borders(xlEdgeTop) etc all work fine.

Any ideas?

 

[mole999]

of you don't force the blue, is there something else in CF that is flipping the colour on code ?

 

[Warship]

thanks fro replying.
I did fail to mention there is no CF either.

Watching the area while stepping through the code it has zero formatting.
Until the BorderAround comes along.

Another Excel oddity I suppose.
Easy enough to recode without BorderAround.