View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default mailto syntax for text to display

Not that I know of. Why not protect the VBAProject?
http://www.ozgrid.com/VBA/protect-vba-code.htm



--
Regards
Dave Hawley
www.ozgrid.com


"Jason Falzon" wrote in message
...
I am successfully using the following: -


Private Sub lblFeedback_Click()
Link = ?subject=Subject"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub

Is it possible to hide the email address and put e.g. "ADMIN" with
something
similar to the text to display used in the Outlook address book?