Updating Hyperlink with sheet name change?
 

Hi, I am using a worksheet with hyperlinks pointing to cells in the worksheet as a template. How do I get the hyperlinks to update so they refer to a new sheet name? Right now I am manually removing and recreating all the hyperlinks.

TIA


Todd

Updating Hyperlink with sheet name change?
 

use the hyperlink worksheetfunction.

you'll have to be VERY carefull with it's arguments.

syntax which works for me:
=hyperlink("[c:\path\my work book.xls]#'sheet name'!a1")


the [] can go around the whole path
the # is used between address and subaddress
the '' should be used to pad the sheet name else names with spaces wont
work)

the only glitch:
a file path with a # cannot be opened... as the function parses it at the
wrong point...



keepITcool

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


"?B?VG9kZA==?=" wrote:

Hi, I am using a worksheet with hyperlinks pointing to cells in the
worksheet as a template. How do I get the hyperlinks to update so
they refer to a new sheet name? Right now I am manually removing and
recreating all the hyperlinks.

TIA


Todd