Have gridlines appear around mouse cursor in Excel

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top