I have an Excel Workbook that I wrote using Excel 97 (or similar). It makes extensive use of hyperlinks, where the whole cell is one colour and you click on the cell to jump to a different sheet.

The people using this have now partially migrated to Vista and I think Excel 2007. The hyperlink now only works when you click on the text and now anywhere in the cell. I appreciate this is how a hyperlink is supposed to work, but the functionality of the workbook is reduced.

Is there a way of forcing the hyperlink to be the whole cell and not just the text?

Many thanks.