I have a multi-worksheet workbook that I am using hyperlinks to move from worksh

Question

I have a multi-worksheet workbook that I am using hyperlinks to move from worksheet to worksheet. Is there a switch I can set or a feature I can use to force the cell I am linking to appear in the upper left hand corner of the worksheet display? All is fine if I hyperlink to cell A1 but if I hyperlink to cell A42 it will appear in the lower left hand corner of the screen or cell Z1 will appear in the upper right hand corner.

Is there anything I can do or am I stuck with this?????

Thank you in advance for your assistance!!!!,

Explanation / Answer

Place this code in Thisworkbook module of the workbook.

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
Application.Goto Reference:=ActiveCell, Scroll:=True
End Sub

Sets any target cell to top left corner of sheet.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.