Creating a hyperlink shortcut in the spreadsheet.

[gtton]

I was wondering if anyone knows the macro to create a hyperlink in th
spreadsheet itself and not the toolbar. I would like to create
business form so clients can link their website onto the Exce
spreadsheet cell. Thanks, Gary

 

[Anne Troy]

You can hyperlink to any worksheet by hitting Insert-->Hyperlink. Choose
BOOKMARK. If you need to jump to a specific cell, just go to that cell, and
Insert-Name-Define and give it a one-word name. Then, it'll appear in the
bookmark list.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[gtton]

Thanks for the reply. I found a macro for open file...

Sub TestIt()
NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls)
*.xls", Title:="Please select a file")
If NewFN = False Then
' They pressed Cancel
MsgBox "Stopping because you did not select a file"
Exit Sub
Else
Workbooks.Open Filename:=NewFN
End If
End Sub

....now I'm looking for something similiar that does the shortcuts
hyperlinking and send to--->mail recipient (as attachment