Vista Office Display

S

Stephanie

We having trouble with making the gridlines in Excel to come up darker on a
new PC - is there a function that we can change - it's unusable
 
G

Gord Dibben

Vista is a MS Windows operating system.

Do you mean MS Office 12(2007)?

I don't have 2007 yet but maybe this will help.

Click the office icon in upper left corner, select Advanced, and dig down to
Display ...worksheet, to find the grid settings.


Gord Dibben MS Excel MVP
 
J

JLatham

Stephanie,
In Excel 2007 click the 'Office Button' then click the [Excel Options]
button near the lower right corner of the displayed information.
In the Options window choose [Advanced], scroll down some and you'll find a
section on "Display Options for this Worksheet" and it has the option to
hide/display gridlines and to change their color!
It's a per-sheet setting (not my fault!). I even tried selecting all sheets
in the workbook and then changing this setting, but at that point it showed
"Multiple Selected Worksheets" as the chosen sheet and none of them got
changed.
 
J

JLatham

Perhaps this code will help some - it will change the gridlines on all sheets
in a workbook to color of your choice. You can experiment with the
..ColorIndex value to get one that works best on that system. You could put
this code into personal.xls so it would be available for use in other
workbooks in the future on that system.

Sub SetGridlineColorForAllSheets()
Dim anySheet As Worksheet
Dim startSheet As String

startSheet = ActiveSheet.Name
Application.ScreenUpdating = False
For Each anySheet In Worksheets
anySheet.Activate
ActiveWindow.GridlineColorIndex = 1 ' 1=black, 3 = red
Next
Sheets(startSheet).Activate
Application.ScreenUpdating = True

End Sub
 
Top