Hyper link and sheet name

[Emily]

Suppose I have several hyper link in Column A which link to different worksheet in the same workbook. It is possible to update the link when sheet name is changed?

Thanks

 

[XL-Dennis]

This message was edited by XL-Dennis on 2002-11-14 17:14

 

[Emily]

Dennis

Every time I regenerate the content, all sheet point to A1. I want the link location unchanged, is it possible?

Thanks

 

[XL-Dennis]

Emily,

Does the link location differ from sheet to sheet or is it the same cellreference?

If the case is the later then You can change the cellerefence in
....wsBlad.Name & "'!A1" to the wanted cell.

Please mail back if the cellocation differ meanwhile I will test out a possible solution

Kind regards,
Dennis

 

[Emily]

Please mail back if the cellocation differ meanwhile I will test out a possible solution

Kind regards,
Dennis

Yes, I hope you can work it work for me.
Thanks in advance

 

[XL-Dennis]

This message was edited by XL-Dennis on 2002-11-14 17:15

 

[Emily]

Thank you very much

 

[XL-Dennis]

On 2002-11-03 10:49, Emily wrote:
Thank you very much

You welcome

Kind regards,
Dennis

Edit (JPG): Enabled BBCode
This message was edited by Juan Pablo G. on 2002-11-03 11:52