I am trying to create a macro so that I can click a button and a hyperlink is created, referencing a network location where the location is dependent upon a value in another cell.
So for example, the hyperlink to be created in cell E3 would be "=hyperlink("G:\General\Blah\Blah\"cell A9"\file.pdf")"
Also, I want the hyperlink text to just say "ABC"
How does this happen?
Bookmarks