I have used a macro to read a list of rows (a contents tab on a workbook with many tabs) and add a hyperlink to each cell that points to cell A1 in the tabs with the same name. On most workbooks with this contents page it works fine, but occasionally all the fonts are changed to plain, blue and underlined, where they were bold and had different colours before.
Is there a default parameter that's not included that might be set in certain versions of the workbook and not others? Here's the macro. Can anyone see what's wrong?
Bookmarks