Is it possible to change the working cell border color as you move around in
your spreadsheet to find your place easily?

You may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Jeanne wrote:

Is it possible to change the working cell border color as you move around in
your spreadsheet to find your place easily?

--

Dave Peterson

Take a look at this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim v As Variant
v = Array(xlEdgeBottom, xlEdgeTop, xlEdgeRight, xlEdgeLeft)
For Each r In ActiveSheet.UsedRange
With r
For i = 0 To 3
..Borders(v(i)).LineStyle = xlNone
Next
End With
Next

For i = 0 To 3
With ActiveCell.Borders(v(i))
..LineStyle = xlContinuous
..Weight = xlThick
..ColorIndex = 7
End With
Next
End Sub



Right-click on the tab and paste the code into the window that opens.


Regards,
Ryan---



--
RyGuy


"Dave Peterson" wrote:

You may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Jeanne wrote:

Is it possible to change the working cell border color as you move around in
your spreadsheet to find your place easily?

--

Dave Peterson

I think I'd use Target instead of activecell. And instead of activesheet, I'd
refer to it using the Me keyword. And declaring all the variables you use is
always a good idea.

Did you mean to post this as a followup to my response? Was it meant for the
OP?


ryguy7272 wrote:

Take a look at this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim v As Variant
v = Array(xlEdgeBottom, xlEdgeTop, xlEdgeRight, xlEdgeLeft)
For Each r In ActiveSheet.UsedRange
With r
For i = 0 To 3
.Borders(v(i)).LineStyle = xlNone
Next
End With
Next

For i = 0 To 3
With ActiveCell.Borders(v(i))
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 7
End With
Next
End Sub

Right-click on the tab and paste the code into the window that opens.

Regards,
Ryan---

--
RyGuy

"Dave Peterson" wrote:

You may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Jeanne wrote:

Is it possible to change the working cell border color as you move around in
your spreadsheet to find your place easily?

--

Dave Peterson


--

Dave Peterson