Run macro when hyperlink makes another cell Active-CodePudding

Home > Back-end > Run macro when hyperlink makes another cell Active

Run macro when hyperlink makes another cell Active

Time：07-18

Looking for ability to execute code below, after hyperlink is clicked.

Example: Hyperlink in A2 selects cell A300. When A2 is clicked and cell A300 is now an active cell, need below code to run.

ActiveWindow.ScrollRow = ActiveCell.Row

CodePudding user response：

This solves it:

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