grid lines
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 -
|