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

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

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 -

Hi Susan,
You were almost there, all you had to do was record a macro :-)

With ActiveWindow
.DisplayGridlines = True
.GridlineColorIndex = 55
End With

It's worth noting this is one of the few things that requires the sheet to
be active and in code might require both the workbook and the worksheet to
be programmatically activated.

Regards,
Peter T

"Susan" wrote in message
...
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 -

that's me, always trying to do things the hard way! i didn't even
think of recording a macro, i was so busy trying to write the
code..... thanks!
(still don't even know what the OP wanted, macro or not.)
susan


On Jul 1, 4:12*pm, "Peter T" <peter_t@discussions wrote:
Hi Susan,
You were almost there, all you had to do was record a macro :-)

* * With ActiveWindow
* * * * .DisplayGridlines = True
* * * * .GridlineColorIndex = 55
* * End With

It's worth noting this is one of the few things that requires the sheet to
be active and in code might require both the workbook and the worksheet to
be programmatically activated.

Regards,
Peter T

"Susan" wrote in message

...
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 -- Hide quoted text -

- Show quoted text -