For example - the default border color is black. Can I chnge it to red?

Hi!

You would have to change the default color of the gridlines then the format
borders default color will also change.

ToolsOptionsView

Check Gridlines then select a color from the drop down.

Biff

wrote in message
oups.com...
For example - the default border color is black. Can I chnge it to red?

Thanks! But can I now change the pattern of grid's borders. Now it
isn't solid !!!!
R.M.

Hi!

The only way that I know of is to format the range of cells and then select
the border style you want.

I guess you could have a Workbook_Open event macro to do this but I can't
help with that.

Biff

wrote in message
ups.com...
Thanks! But can I now change the pattern of grid's borders. Now it
isn't solid !!!!
R.M.

wrote:
For example - the default border color is black. Can I chnge it to red?

Try Format Style Modify Borders select Red, click Outline ok

Geoff


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200511/1

Yes. But in this case I have already selected borders in border tab. I
don't want it! Meybe should I it in registry change?