Select Hyperlink Without Activating Link. In order to select a cell with a hyperlink you need to use your right mouse button instead of your left. The HyperlinksAdd Method can add a hyperlink to a cell using VBA.
It also avoids an isse with SelectionChange that if the user is navigating with the keyboard the link cell could get selected without clicking causing unexpected behavior. One common method is to generate a list of links without context to determine the content of the page. Then press F5 key to run this code and a prompt box is popped out to remind you select the cells that you want to convert to clickable hyperlinks see screenshot.
One common method is to generate a list of links without context to determine the content of the page.
This method might work for just a couple of links. Just Right-click the cell and then click Hyperlink or. Since it uses the FollowHyperlink event it will work no matter where your hyperlink is located even a merge cell. To select a cell that contains a hyperlink without activating the hyperlink click the cell and hold the mouse button down a half second or so.
