Possibility to use hyperlinks in a shared Excel workbook

chef_carol

I've got an Excel document where we've enabled the Track Changes functionality in order to capture who changes what and when - for this you'd have to share the workbook. We've now found that we want to make it a bit easier to navigate in the file (as it's getting quite big) - and in this process we'd like to make use of hyperlinks between tabs. Now I've looked around a bit to find out how to do this - because as you may know Excel doesn't allow...

Originally asked by Thomas Tilsted on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

Several other sites suggests to unshare, add links and then reshare the workbook but this is somewhat annoying because it prevents users that currently have it open from properly saving if you unshare while they have it open even if you reshare before they save. No need to unshare then reshare just set the cell's Formula property to equal to =HYPERLINK(link, text) Sheets(targetSheet).Range(targetRange).Formula = _ "=HYPERLINK(" & Chr(34) & "http://www.google.ca/" & Chr(34) & ", " _ & Chr(34) & "Click to go to google" & Chr(34) & ")" Chr(34) are double quotes The result formula is =HYPERLINK("http://www.google.ca/", "Click to go to google") This is the workaround in VBA to allow hyperlinks...

Full answer by RCamba: https://stackoverflow.stackexchange.com/a/38983585 (CC BY-SA 4.0).

Need it done for your business? UphillTech.