Quick Tools - Hyperlink Tools

Estimated reading time: 4 minutes

Overview

The Hyperlink Tools within Quick Tools deal with Interject Hyperlinks.


Sets the scope for hyperlinks to the sheet they are contained in for all hyperlinks in the current cell or all selected cells.

When you paste a hyperlink into another sheet, Excel retains the scope for that hyperlink so it is not set to the sheet you are pasting it into. To demonstrate this, follow these steps:

Step 1: First select a hyperlink in the current sheet:


Step 2: Next paste it to another sheet:


Step 3: Right click the cell and select "Edit Link":


Notice the scope of this Hyperlink is still set to the original sheet "Customer Aging":


Step 4: Click on "Reset Hyperlink Targets for Selection" in Quick Tools and "Run and Close":


Notice the scope has been set correctly to the current sheet "Example":


Opens a window to create or edit an Interject Hyperlink.

To demonstrate this, you will setup an Interject hyperlink that opens the Report Library.

Step 1: First select an empty cell and enter a name for the hyperlink:


Step 2: Click on Quick Tools "Create/Edit Interject Hyperlink" and then "Run and Close":


You can select the type of Hyperlink you want to add. In this case select "Interject Report Library" from the dropdown:


Step 3: Next you need to enter a reference for the hyperlink. You can either select a "Target Cell Name" or a "Cell Address". The "Target Cell Name" option will display a dropdown list of all the range names in the sheet. In this case, use the "Cell Address" option and enter the cell reference of your hyperlink name and "Set Hyperlink":


The Hyperlink is created!:


Create/Edit Interject Hyperlink : Preserving Styles

You can set up a predetermined styling for the Hyperlinks by using a defined name. When a cell has the defined name of "InterjectConfig_HyperlinkStyle", Interject will use the styling of that cell to apply to a hyperlink that is created.

Step 1: Select a cell that matches the formatting you wish the Hyperlinks to have and define the cell with the name "InterjectConfig_HyperlinkStyle":


Step 2: Now create another hyperlink using the method in the previous section:


Notice the new hyperlink has the same style as the cell with the defined name "InterjectConfig_HyperlinkStyle":