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

--
gtto
-----------------------------------------------------------------------
gtton's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2472
View this thread: http://www.excelforum.com/showthread.php?threadid=38288

[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

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

http://www.excelforum.com/member.php?action=getinfo&userid=24721

View this thread: http://www.excelforum.com/showthread.php?threadid=382882

[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

--
gtto
-----------------------------------------------------------------------
gtton's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2472
View this thread: http://www.excelforum.com/showthread.php?threadid=38288