Hyperlink from Modular Worksheet to Freeform Worksheet

Hi Alexander,

Modano does not currently support the insertion of hyperlinks into module components ranges that reference ranges or range names within freeform sheets, but you can work around this using a shape, as follows:

1. Insert a shape into a freeform sheet (e.g. the Overview sheet):

2. Right-click on the inserted shape and select the Link menu item:

3. In the Insert Hyperlink dialog, select the hyperlink target range or range name. I also click the Screentip button and add a nice screen tip:

4. Copy and paste the shape containing the hyperlink into your module component, as I've done below into the Revenue module assumptions component:

5. Size the pasted shape over the range in which you want to have the hyperlink and then set both its Line and Fill color to None:

6. Insert your hyperlink text into the range underneath the (now invisible) shape and style the range using the Hyperlink Text style (Build tab, Outputs menu, Hyperlink Text):

The outcome will be a hyperlink within your module component to your freeform content.

The same approach can be used to add hyperlinks to module components to websites, etc. You might even want to keep the button visible and simply use buttons for hyperlinks if you prefer this look and feel.

M.

Hi Alexander

You could also use Excel's Hyperlink function. The attached shows a basic example from a module to a freeform sheet using this function (see the "Module" sheet). It also manages to avoid getting the freeform formula warning, due to each part of the function being a string.

You will see in the example that I have named the target cell and used that name in the Hyperlink function (encased by the "#..." which is needed for the function to work). You could also have "#Freeform!C5" as the reference, but if you insert rows/columns above/left of C5 it is unlikely to work the way you want it to, so named ranges is best unless you are trying to hit cell A1.

Cheers

Tim

Nice approach Tim, a very simple and effective workaround!

I am trying to do the same but there is no link option. What can I do? I am working on a multi-business unit dynamic template., TIA

Brilliant, Michael.  Worked for me.