can you hyperlink to cells in a excel ss?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what i a trying to do is create hyperlinks in fp that link back to a excel
cell. what i have got it to do is when i click the link it opens the excel wb
and goes to the last cell i defined a name for.. ex: workbook.xls#abc, but it
will only link back to the last defined cell. is it possible to basicaly do
that for all the cells, mutilply hyperlinks that go to different cells in
the same workbook.. i dont care how it is done..
 
so i just cant believe that i can hyperlink back to the last cell that i
defined, but i am not able to like back to other defined cells. i mean i am
able to click a hyperlink and it open excel and go to that cell no matter
where it is in the ss. well does anyone have any other alternative methods or
ways i can to this even if thier is other links or programs needed??
 
You might want to try the Excel newsgroup as this is really not a FP related question.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
You need to define the workbook#worksheet!namedrange in the link
workbookname.xls#sheetname!rangename

works best if your sheets are named (rather than using defaults such as sheet1, sheet2, etc)
--




| so i just cant believe that i can hyperlink back to the last cell that i
| defined, but i am not able to like back to other defined cells. i mean i am
| able to click a hyperlink and it open excel and go to that cell no matter
| where it is in the ss. well does anyone have any other alternative methods or
| ways i can to this even if thier is other links or programs needed??
|
| "Teri Carnright" wrote:
|
| > It won't happen - sorry...
| >
| > Teri
| > :)
| >
| >
| > "daneyb" wrote:
| >
| > > what i a trying to do is create hyperlinks in fp that link back to a excel
| > > cell. what i have got it to do is when i click the link it opens the excel wb
| > > and goes to the last cell i defined a name for.. ex: workbook.xls#abc, but it
| > > will only link back to the last defined cell. is it possible to basicaly do
| > > that for all the cells, mutilply hyperlinks that go to different cells in
| > > the same workbook.. i dont care how it is done..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to hyperlink an archived worksheet to an index page 0
hyperlink to a pdf document 1
Hyperlinks in Cells Wrapping Weirdly 4
Excel VBA 1
Can UDF return a customized hyperlink? 3
Activating hyperlinks 3
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlink to cells in other workbooks keep changing 3

Back
Top