How do I embed a .lnk file in an Excel form?

S

SIMPSBA

I would like to embed a hyperlink in an Excel form to a file that resides in
an Outlook public folder and can't figure out how to do it. Anybody know if
this is possible?
 
D

Dennis Tucker

Setup a click event with one of the visual controls on the form. Inside this event use the following


ActiveWorkbook.FollowHyperlink Address:="http://www.gohere.com", NewWindow:=True This address "http://www.gohere.com" needs to be the address of any document you want that is accessible.Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2016 Add-in that creates an html signature doesn't embed images(logos). How can I do this ? 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel file won't save to iCloud on Mac 0
Merging from an Excel file with graphics 1
How to Select Multiple Emails using Surface Pen 0
can I insert/embed a word document in a single excel cell? 1
How do I embed SharePoint document properties in Excel 2007? 3
Embed Excel into PDF file 3

Top