Hyperlinks

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I am using hyperlinks in my files. On occasion I need to
change the name of my file. When I do this the hyperlinks
that I had created refer back to the previous file name
before it was changed. I would like the hyperlinks to
automatically refer to the new file name if it changes. Is
this possible?

Thanks again.
 
you can..


if you use hyperlink formula iso insert hyperlink

=hyperlink("#sheet2!a4","click me!")

or to avoid hardcoding...
=HYPERLINK("#"&CELL("address";'budget feb'!C4),"Feb")

the # makes it jump within the book :)

For external refs try: (appears the # is not needed,
but he's not great at opening :(, use links/open source..

=HYPERLINK(CELL("address";[hljump.xls]Sheet1!$D$12))




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Back
Top