Auto create Hyperlink to external file

Here is a macro solution. boylers75=replace Yes with hyperlink when entered=Hyperlink.xlsm It assumes that the PDF file is in the same folder as this Excel file.

That waorks great, but the hyperlinkl need to work to a different folder, "\\TUGALW-FP02\DEPT\VE\Returned\". How does this get put into it, tried in vain