EmailSubject Property Example
This example sets the e-mail subject line for the first hyperlink in the first worksheet.
Worksheets(1).Hyperlinks(1).EmailSubject = "Quote Request"