Hyperlink from Modular Worksheet to Freeform Worksheet

HyperlinksFreeform
6 posts / 0 new
Last post
X 0
Hyperlink from Modular Worksheet to Freeform Worksheet

Hi, 

Is there anyway to inset a hyperlink from a modular worksheet to a freeform worksheet? 

I am getting error message as attached. 

Note: this model is based on Modano 8. 

Attachments: 
Michael Hutchens A+ 162

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.

Michael Hutchens A+ 162

Nice approach Tim, a very simple and effective workaround!