Use a name.
Simply select the target cell or cell area. Give it a name in the top name
combobox.
Now edit the hyperlink and replace the numerical cell or area reference by
this name, as in "Sheet2!myname".
Your hyperlink now follows row insertions, and other actions.
--
xlsgen - native Excel generator
http://xlsgen.arstdesign.com
xlsgen RSS feed :
http://www.arstdesign.com/BBS/rssxlsgen.php
"muraz" a écrit dans le message de
...
I have created an Excel spreadsheet with hyperlinks to worksheets within
the
same spreadsheet. However, when I insert rows to here the hyperlink is
linked, the cell does not change to where the link should be connected to.
It stays the same. Any suggestions?