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.
I resolved it for now by defining the row number in Issues register table and using =HYPERLINK("[.\][defined_name]","Go to Hyperlink")
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:
I've attached an example of this approach. I'm not sure whether it's easier than your workaround though.
M.
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!
This is a very nifty workaround.