Certainly can. You can even specify an address within the sheet.
Details of how to create it in Insert / Hyperlink may differ according
to your version of Excel (for example, in Excel 2000 browse to the file
and then click Bookmark).
What you should end up with is a hyperlink like
C:\MyDir\MyFile.XLS#'My Sheet Name'!A1
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|