Using the issues register as glossary - workarounds for hyperlink?

5 posts / 0 new
Last post
Tarjei Kirkesaether A+ 58
TK
Using the issues register as glossary - workarounds for hyperlink?

Are there any workarounds (offset/indirect etc.) to add a hyperlink in a module to a freeform sheet (i.e. the issues register).

I want to add a glossary to my model by using the issues register to simplify the process but I am aware of the limitation regarding hypelinks that they have to be in the same module. If there is a workaround that would be great, otherwise I would just have to refer to the "glossary" tab without hyperlinks.

Tarjei Kirkesaether A+ 58
TK

I resolved it for now by defining the row number in Issues register table and using =HYPERLINK("[.\][defined_name]","Go to Hyperlink")

Michael Hutchens A+ 189

That's a very cool workaround Tarjei, nice work.

You can also use a shapes to insert hyperlinks into module components to freeform content as follows:

  1. Name the hyperlink target range. In this example it's been named 'Hyperlink_Target'.
  2. Insert a rectangle onto a freeform sheet, such as this cover sheet (Insert tab, Shapes menu, Rectangle).
  3. Select the inserted rectangle, right-click on it, and select Link from the shortcut menu.
  4. Add a hyperlink to the shape to the target range name.
  5. Copy and paste the shape containing the hyperlink into the module component you'd like to include the hyperlink.
  6. Remve fill coloring and borders from the shape so it can't be seen.
  7. See the revenue assumptions example in this file.

I've attached an example of this approach. I'm not sure whether it's easier than your workaround though.

M.

Tarjei Kirkesaether A+ 58
TK

Thanks Mike, that’s exactly the kind of workaround I was after!

For my current project the Hyperlink formula will suffice but will definitely keep this in mind for future models where I want to insert cross-module hyperlinks!

Jun Yan A+ 124

This is a very nifty workaround.