i looked in the object browser in visual basic & found that you can do
it via macro..........

Property GridlineColorIndex As XlColorIndex
Member of Excel.Window

but i don't know exactly how to word it in the macro. just thought
i'd throw this in for more help.
susan


On Jul 1, 3:12*pm, Susan wrote:
toolbar - Tools, Options, select View tab, make sure Gridlines is
checked, select the color you want.

if you meant via macro, i don't know.

hth
susan

On Jul 1, 2:58*pm, ranswrt wrote:



How do I set the color of the grid lines on a worksheet to a specific color?
Thanks- Hide quoted text -

- Show quoted text -