Hyperlink

[Zubair]

Dear Expert,

On new computer struggling to download Add-in XL2BB, so attaching screen shots.

Is it possible while pressing hyperlink, the cell to appear on 1st column and row on the screen ? as it always appear last column last row on the screen.

Like in the given example if I press B5 to locate AQ25

The screen is appearing like below, last column last row.

I want like this

Regards

 

[rowebca]

Add this code to the worksheet / followHyperlink:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveWindow.ScrollRow = ActiveCell.Row
ActiveWindow.ScrollColumn = ActiveCell.Column
End Sub

Hope is it what you desire.

Regards,
GB

 

[Zubair]

Thanks rowebca.