Thread
:
Have gridlines appear around mouse cursor in Excel
View Single Post
#
1
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Have gridlines appear around mouse cursor in Excel
Be careful what you ask for. This puts grid lines and borders around
whatever the mouse selects.
toolsoptionsviewgridlinesuncheck
right click sheet tabview codeinsert 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
--
Don Guillett
SalesAid Software
"James Grotjohn" <James
wrote in message
...
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/comm...lic.excel.misc
Reply With Quote