Have gridlines appear around mouse cursor in Excel

J

James Grotjohn

In Excel the gridlines clutter up the look of the screen. But they are very
useful in knowing where to click to make changes and select cells. I would
like to have the gridlines be invisible except in a floating area around the
mouse cursor.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...9-4de3685a0815&dg=microsoft.public.excel.misc
 
D

Don Guillett

Be careful what you ask for. This puts grid lines and borders around
whatever the mouse selects.
tools>options>view>gridlines>uncheck
right click sheet tab>view code>insert this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Borders.LineStyle = xlNone
With Selection
.Borders.LineStyle = xlContinuous
.BorderAround ColorIndex:=3, Weight:=xlThick
End With
End Sub
 
Top