View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default hyperlink image for email

Yep, it works:

Private Sub Image1_Click()
Dim link As String
link = "
On Error GoTo NoCanDo
ThisWorkbook.FollowHyperlink Address:=link, NewWindow:=True
Unload UserForm1
Exit Sub
NoCanDo:
MsgBox "Cannot open " & link
End Sub

Cliff Edwards