Can't change border color

[kotzo]

Hi,

I an working with an excel file created by someone else, and I'm trying
with vba to change the border color of the cells

I failed, even with the normal excel commands.

The color is not changeable ...

I would post the workbook but this is not possible here.

Is there a possibility to help me with this ?

Thanks,

Tzovanis

 

[schielrn]

Right click on the cell you want the cell border to change and go to format cell. Go to the border tab and change the color from automatic and then you have to re-apply the border, it will not change automatically by just changing the color in the drop down. You still have to click and add the border.

Hope that helps and then you can record a macro doing this to get a basic idea of the code involved.

http://www.ehow.com/how_4471236_border-style-color-microsoft-excel.html
http://excel.tips.net/Pages/T002977_Changing_the_Color_of_a_Cell_Border.html

Hope that helps.

 

[p45cal]

Is there a possibility that the borders are put there by conditional formatting, which overrides manual formatting?

 

[kotzo]

Is there a possibility that the borders are put there by conditional formatting, which overrides manual formatting?

Yes the workbook has conditional formating, but still when I delete the
rules I can't change the colors with

 ActiveCell.Borders.ColorIndex = 0

or from the excel menus

 

[p45cal]

Does it come back with an error message?
Is the sheet protected?
Are there any macros/event handlers?

 

[kotzo]

Does it come back with an error message?
Is the sheet protected?
Are there any macros/event handlers?

It's now O.K.

The sheet was protected.

Thanks for the hints

Tzovanis