Hyperlinks/bookmarks

[Tim Smith]

I have created an index (Sheet 1) on an excel spreadsheet with hyperlinks/bookmark referencing to 26 additional sheets in this workbook.

I would like to insert a row in any of the non-index sheets where the bookmark referencing the new row location (one beneath where it once was), currently the bookmark is referencing the old location.

 

[paul]

Right Click on the hyperlink --> Edit Hyperlink -->change
the cell reference number

-----Original Message-----
I have created an index (Sheet 1) on an excel spreadsheet

with hyperlinks/bookmark referencing to 26 additional
sheets in this workbook.

I would like to insert a row in any of the non-index

sheets where the bookmark referencing the new row location
(one beneath where it once was), currently the bookmark is
referencing the old location.