Highlight a row
 

I have set up a spreadsheet with bookmark links to other worksheet rows...Is
it possible to highlight the row when i enter it using the link.

Cheers

Highlight a row
 

First off do you want to select the row or highlight it a certain color, here
is the way to select the entire row:

In your visual basic editor place this in the worksheet tab your hyperlink
is pointing to.

Private Sub Worksheet_Activate()
ActiveCell.EntireRow.Select
End Sub

Hope this helps

Sandy

"pjy" wrote:

I have set up a spreadsheet with bookmark links to other worksheet rows...Is
it possible to highlight the row when i enter it using the link.

Cheers