Hyperlinking the easy way!
Hyperlinking in Excel is painful, way too many clicks, navigation is poor and then the displayed name is a gamble.
Here’s a couple of codes that automate the process so much more efficiently.
They utilize the HYPERLINK formula instead of using the typical hyperlink method.
The reason to use the hyperlink formula is that hyperlinks in excel workbooks will not continue to be fully functional if you save the workbook in another directory, there are workarounds which include changing the Hyperlink base of your workbook however this is still finicky at best.
Download the below codes:
Hyperlink a folder
Hyperlink a file
