View Single Post
  #3   Report Post  
 
Posts: n/a
Default

I tried this, here is the contents of the cell:

=HYPERLINK('\\FIL-NW02-06
\MPTTechTeamLeaders\8_Tech_Team_Scorecard\Reddy Team
Scorecards\[2005_Define_Scorecard_Hixson.xls]Scorecard -
Tech Group'!K12)

and I get the little hyperlink hand icon but when I click
nothing happens.

Wayne

-----Original Message-----
Check out the HYPERLINK function.
Example:
=HYPERLINK("[C:\Temp\MyFile.xls]Data!$C$2","Test")
will show the word 'Test' in the cell. When selected,

the hyperlink will
take you to the 'MYFILE' workbook, the 'Data' worksheet,

cell C2.
HTH,
Gary Brown

"Wayne" wrote in

message
...
I have a paste link cell in a spreadsheet, referring to

a
source cell in another spreadsheet and cell. Is there a
way in VBA to open that source spreadsheet and "jump"

to
the source cell?

Wayne



.