Excel Stuff
The solution to this problem is the following:
(1) Open
Microsoft Visual Basic by right clicking on any sheet tab, and selecting
“View Code”
(2) Double
click on “This Workbook” in the Project window.
(3) Copy and
paste the following code into the “This Workbook” window:
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, _
ByVal
Target As Hyperlink)
With
ActiveWindow
.ScrollRow = Range(Target.SubAddress).Row
.ScrollColumn = Range(Target.SubAddress).Column
End
With
End
Sub
