If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
highlight only complete row currently being used.
Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks |
#2
|
|||
|
|||
highlight only complete row currently being used.
There are methods using sheetchange events but the easiest method is to use
Chip Pearson's RowLiner add-in. http://www.cpearson.com/excel/RowLiner.htm Just a note...........Rowliner won't work on protected sheets. If your sheet is protected you need event code. Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 13:25:01 -0700, 2MShad wrote: Is there a setting that will highlight a complete row if your cursor is in that row. I know the row number will be highlighted. Thanks |
#3
|
|||
|
|||
highlight only complete row currently being used.
As Gord suggests, Chip's RowLiner really zeros you in on a secific cell,
along with the column and the row. If you should only need to highlight a smaller portion of the row you could use this little 'diddy to do so. It is adjustable to the width you may want, what column to start and end highlighting. Other colors OUTSIDE the designated area, Data, are safe. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Data As Range Dim i As Integer Dim j As Integer Dim k As Integer Dim cells As Range i = 2 j = 8 k = ActiveCell.Column() Set Data = Range("B8:K22") Data.Interior.ColorIndex = xlNone If ActiveCell.Row 8 Or ActiveCell.Row 22 Or _ ActiveCell.Column 2 Or ActiveCell.Column 11 Then Exit Sub End If ActiveCell.Offset(0, -(k - i)). _ Resize(1, 10).Interior.ColorIndex = 35 '26 End Sub HTH Regards, Howard "2MShad" wrote in message ... Is there a setting that will highlight a complete row if your cursor is in that row. I know the row number will be highlighted. Thanks |
#4
|
|||
|
|||
highlight only complete row currently being used.
Besides you may try to use "workbook navigation" Excel addins from below
site. It has row highlight options with undo also works. http://shahshaileshs.web.officelive.com/Addins.aspx Regards, Shailesh Shah http://shahshaileshs.web.officelive.com/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://shahshaileshs.web.officelive.com/MenuAddins.aspx Free Exshail Classic Menu for Excel-2007 http://shahshaileshs.web.officelive....ssic_Menu.aspx "2MShad" wrote in message ... Is there a setting that will highlight a complete row if your cursor is in that row. I know the row number will be highlighted. Thanks |
Thread Tools | |
Display Modes | |
|
|