Thread: How do I embed a .lnk file in an Excel form?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dennis Tucker Dennis Tucker is offline
external usenet poster
  
Posts: 140
Default How do I embed a .lnk file in an Excel form?
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

"SIMPSBA" wrote in message ...
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?
Reply With QuoteReply With Quote