Hello,

I am hyperlinking text boxes in one sheet to certain cells in another sheet
of the same workbook. However, when I add a row before the cells, the text
boxes' hyperlinks do not shift down one letter but rather remain unchanged.

For example, I have a text box link to D9, and I insert a row between rows B
and C, which would make the cell I'm interested in to switch from D9 to E9.
However, the link remains to link to D9.

How can I fix this? Thanks.