'xl2002 object.Add(Anchor, Address, SubAddress, ScreenTip, TextToDisplay)
'xl97 object.Add(Anchor, Address, SubAddress)

Sub MoreTests()
ActiveSheet.Hyperlinks.Add anchor:=ActiveCell, _
Address:="C:\Documents and Settings\user\My Documents\Excel Files\Expenses.xls", _
SubAddress:="Sheet2!B14", ScreenTip:="Click to opens this file", TextToDisplay:="Expense File"
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Chris"
wrote in message
I can't find out how to hyperlink to a specific sheet in a file, so I am
trying to write some event code, so when a particular cell is selected it
opens the file and selects the correct sheet. Should I be able to do it
through hyperlink or is code the only way?
If code is the only way, can someone help I can't get it to work?