excel on the web

S

sean5215

I have an excel spreadsheet that will be used online. When working in excel
and using the program the calls to open a hyperlink and email to an address
work fine, but when published to the web I cannot get them to work properly.
Here is the code:

Sub lblMail_Click()
Link = "mailto:[email protected]"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Unload Me
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub

Sub lblWeb_Click()
Link = "http://www.northernfood.com"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Unload Me
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top