Jim

Yep, that's the one. I've used the same macro in a user form to give
me easier accessibility.

Stephen Allen

On 4 Oct, 15:44, "Jim Rech" wrote:
I haven't used hyperlinks much but I see that in Excel 97 you could create a
hyperlink like "C10" while in Excel 2003 the active sheet's name
automatically added (e.g., Sheet1!A10) whether you want it or not.

And since hyperlinks are just text entries they do not automatically get
updated, like formulas do, when the sheet name is changed, so they are
broken by doing so.

I find though that you can create a 'hyperlink without sheet name' in Excel
2003 with a macro like this:

ActiveCell.Hyperlinks(1).SubAddress="c10"

If no one has a better suggestion this may be your only workaround.