If you open the workbook in xl2007, don't you get the offer to change these
names (prefacing them with an underscore, like: _TN99).
If that's true, then ...
If you used the =hyperlink() formula, maybe you can select that range and do an
Edit|Replace (or xl2007 equivalent).
If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But
the good news is David McRitchie has done most of it for you:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)
If you're new to macros:
Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm
(General, Regular and Standard modules all describe the same thing.)
Miki wrote:
I have generated an excel worksheet in 2003 with a list that every row has
one cell with hyperlink to another sheet within the same workbook. In the
second sheet I have named each cell/box with TNxx (xx represents sequential
number). Then, in each box I have added a long text. It was working fine in
2003, and my lists grew up to hundreds of rows.
When I have moved to Excel 2007, I got an error message that TNxx is a
reference to a cell in a sheet (I assume that Excel 2003 did not supported
this range of columns), and got recommendation to fix it automatically and it
does not work.
Currently I am saving the file in 97-2003 format, but I would like to move
to 2007.
Do you have any suggestion how to solve this hyperlink problem?
--
Dave Peterson