Maintaining in-doc hyperlinks when rows/cells change
I think using Names is the safest.
But if you're using the =hyperlink() worksheet function, you could make sure
that both workbooks are open when you make changes. Since it's just a formula,
excel will adjust them when you make changes.
Ittai Gilat wrote:
Suppose I want to hyperlink a row in another worksheet. I tried using names,
but they get messed up after rows are added/moved/deleted. Is there a way to
get sticky names that move with a row/column/cell?
--
Dave Peterson
|