![]() |
mailto syntax for text to display
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? |
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? |
All times are GMT +1. The time now is 10:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com