Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
What is the syntax for function text parameters in VBA (Excel 07) | Excel Worksheet Functions | |||
Count Text Syntax | Excel Discussion (Misc queries) | |||
Mailto hyperlinks | Excel Discussion (Misc queries) | |||
mailto addresses | Excel Worksheet Functions |